--那就用循环啦:
declare @i int,@ic int
select @i=1,@ic=max(lineid) from 表while @i<=@ic
begin
insert into 一个表 select * from 表 where lineid between @i and @i+1
set @i=@i+2
end
declare @i int,@ic int
select @i=1,@ic=max(lineid) from 表while @i<=@ic
begin
insert into 一个表 select * from 表 where lineid between @i and @i+1
set @i=@i+2
end
=====================
学习~~