select 'a' as F, * into #t1 from authors order by au_id asc

select 'b' as F, * into #t2 from authors order by au_id desc

select * from #t1
union all
select * from #t2

drop table #t1
drop table #t2