Select Id, 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)) Aleft Join (SELECT (SELECT (SELECT (MAX 1) / 2 As Cut from #t)) AS NID, ID, NAME from #t where nid> (SELECT (Max (NID) 1) / 2 as cut from #t)) Bon A.NID = B.NID
