wware (4/25/2011)
Interesting question. I had no problem with the semantics of the question or answer.Wondering if anyone can think of a real world example where one might want to use "ORDER BY NEWID()?" Just curious.
I did when doing reindexing during business hours. I wanted to make sure to not lock to same table over and over again so newid() on the final query made the cut... especially combined with waitfor delay