RE: execute stored procedure with order by

SSC Guru

Points: 286609

November 8, 2011 at 1:16 pm

Again, have you tried?

Someday you will wish you had ordered by column name instead of ordinal position. All you gain by ordinal position is ambiguity.

select SomeColumn from MyTable

union all

select Othercolumn from SomeOtherTable

order by SomeColumn

Aside from being more ambiguous, this is the same thing.

select SomeColumn

union all

select Othercolumn

order by 1

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.