Christian Buettner-167247 (12/14/2009)
Hm, is someone able to explain this?Same code as before, but positioned order by (1 instead of i) and "-" as separator for better readability.
As said in explanation:
The second construct is not documented, but works this same way on MS SQL Server 2000, 2005, and 2008.
I don't know how the undocumented construct works. But there are another questions: What is the first column in your select? Is it OK to order on missing column?