nicolasallan (2/25/2010)
... beware of the ORDER BY gotchya. ... I believe this is a SQL Server bug..?
If it is a bug and you can create a script to reproduce it, please post it here and at ">https://connect.microsoft.com/dashboard/?wa=wsignin1.0
Readers of this thread can then reproduce it and confirm it as a bug.