求一存储过程，一条记录变为多条记录
表A
name     startno   endno
aaaa     120           125
bbbb     110           160
插入表B中为
name       no
aaaa       120
aaaa       121
...         ...
aaaa       125
bbbb       110
bbbb       111
...         ...
bbbb       160



------解决方案--------------------
declare tb cursor for select name,startno,endno from from tablea
declare @i int
declare @a1 int
declare @a2 int
declare @name varchar(20)

open tb
fetch next from tb into @name,@a1,@a2
while @@fetch_status=0
begin
set @i = @a1
while (@i <= @a2)
begin
INSERT tableb (name,no) VALUES(@name,@i)
s et @i = @i + 1
end

fetch next from tb into @name,@a1,@a2
end
close tb
deallocate tb
------解决方案--------------------
--如果是100-2000就插不完
--------------------------------那就多产生行数，那就用交叉
Select id=identity(int,0,1) into #t from syscolumns as a,syscolumns as b