两列的报表-sql语句

select identity(int,1,1) as nid,* into #t from table1

select
    a.id,a.name,b.id,b.name
from
    (select nid,id,name from #t where nid <= (select (max(nid)+1)/2 as cut from #t)) a
left join
    (select (nid-(select (max(nid)+1)/2  as cut from #t)) as nid,id,name from #t where nid >  (select (max(nid)+1)/2  as cut from #t)) b
on a.nid = b.nid