>...what is better: ... order by company, OrderNumber or ... order by 1,2 ?

Hi Nadya,

I don't know if the SQL Server world has a preference, but I've used both methods. Using numbered columns eliminates a lot of typing, but if you add a column somewhere in the middle of your field list you have to re-check your ORDER BY numbers.