Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nirangava
Starting Member
4 Posts |
 Posted - 2011-05-31 : 02:22:25
|
| im having a view that get the recourd like i mentioned bellow.The last column contain a nchar type and i convert that in to a time using convert(nchar, sttm, 108) coz i need to order this according to the time slot. i tryied using5/30/2011 0:00 Monday DR. PRIYANTHA PERERA PAEDIATRICIAN 03:00 PM 05:00 PM 5/30/2011 0:00 Monday DR CHAMILKA JAYASINGHE PAEDIATRICIAN 04:00 PM 06:00 PM 5/30/2011 0:00 Monday DR. PADMAKANTHI PAEDIATRICIAN 06:00 AM 07:00 AM 5/30/2011 0:00 Monday DR. SHAMAN RAJINDRAJITH PAEDIATRICIAN 06:00 AM 08:00 AM 5/30/2011 0:00 Monday DR. PADMAKANTHI PAEDIATRICIAN 06:00 PM 10:00 PM 5/30/2011 0:00 Monday DR. LILANTHI DE SILVA PAEDIATRICIAN 06:30 AM 07:30 AM 5/30/2011 0:00 Monday DR. SHAMAN RAJINDRAJITH PAEDIATRICIAN 06:30 PM 10:00 PM 5/30/2011 0:00 Monday DR. PRIYANTHA PERERA PAEDIATRICIAN 07:00 AM 08:00 AM 5/30/2011 0:00 Monday DR CHAMILKA JAYASINGHE PAEDIATRICIAN 07:00 AM 08:00 AM 5/30/2011 0:00 Monday DR. MYRNA CABRAAL PAEDIATRICIAN 07:30 AM 08:30 AM 5/30/2011 0:00 Monday PROF. HARENDRA DE SILVA PAEDIATRICIAN 07:30 AM 08:30 AM 5/30/2011 0:00 Monday DR. MYRNA CABRAAL PAEDIATRICIAN 07:30 PM 08:30 PM SELECT SEDate, day, Name, speciality, entm, actve, Code, Room, RefNo, [No of channel] FROM VV_CH_Today WHERE (SEDate = '5/30/2011') AND (speciality = 'PAEDIATRICIAN') ORDER BY Name, sttm |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-31 : 03:37:33
|
| What's the data types of the sttm column?--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Order By