MMartin1 (2/2/2016)
This data could be pre-sorted elsewhere (like in Excel) imported, and the user is only interested in the columns presented to us (not the sort column). In the case where order is guaranteed
Editor: Comment removed
Don't you really know that pre-soring anything in Excel or any other external application does not guarantee that the set will be imported into a SQL Server table in the same order?
Don't you really know that even if the data physically placed in a table in a desired order (which is probably even enforced with a clustered primary key) there is no guarantee it will be selected by a query in the same order, unless you enforce the order of the records in the query itself?
Editor: Comment removed
_____________
Code for TallyGenerator