One minor mistake i found that, You need output like "Apr 9 2013 11:38AM", But below all queries give today day. oops !!! 🙂
Hi Vinay,
Actually, I run this scenario on 9 April and put it here for QOTD. I was not aware when it will going to be published....
Hmmm I missed the word 'like' 😛 it should be written as 'If I want output like this:' :hehe:
Thanks for prompting me 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/