Browse Site by Tags

Order By is only for the result set of your query; it has nothing to do with the physical arrangement of records in your second destination table. How the records are physically placed in the table's pages depends on what its clustered index is. If you truly want to have the records physically sorted...