Arthur Kirchner (6/18/2013)
.... and the ORDER BY 1 means ORDER BY the first column expression the SELECT Statement.Just adding this because I didn't know that not a long while ago...
To add to this, it is also a bad practice. You should not order by the ordinal position, instead you should order by the name of the column. It eliminates confusion and possible issues down the road. If the column order changes, the results will be ordered incorrectly unless you also remember to change the order by. :w00t:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/