May 30, 2013 at 11:41 pm
I messed with the question... But like your No cheating comment....:-P
June 1, 2013 at 5:00 am
Thanks Ron for the QoTD. Today, I've learned that "TOP WITH TIES" returns ties only iff the last row is tied. Darn, all along, I was thinking TIES works on all rows.;-)
Its too bad, I have to go back and check all the hundreds of procedures. 🙁 But I think it should not function like it, rather it should work on all tied rows.
--Ramesh
June 13, 2013 at 10:58 am
interesting question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 17, 2013 at 12:52 am
Good one. 🙂
June 26, 2013 at 10:27 pm
Nice one
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply