okay,so kinda odd. i used to do this all the time in 2008, but now it wont work.
if i take a table, and sort it into another table, it doesnt sort.
this works fine (as far as what's displayed:
select * from append.dbo. order by zip10
but when i drop it into a table to export it, it's no longer sorted.
select * into append.dbo.[01001_sorted] from append.dbo. order by zip10
select * from append.dbo.[01001_sorted]