select code,name,num into #temp from temp where num=1declare @i int declare @code char(3) declare @name varchar(50) declare @num int declare cur_devide cursor for select code,name,num from temp where num>1 open cur_devide fetch next from cur_devide into @code,@name,@num while @@fetch_status = 0 begin set @i=0 while @i<@num begin insert into #temp values(@code,@name,1) set @i = @i + 1 end fetch next from cur_devide into @code,@name,@num end close cur_devide deallocate cur_devideselect * from #temp order by code
into #temp
from temp
where num=1declare @i int
declare @code char(3)
declare @name varchar(50)
declare @num int
declare cur_devide cursor for
select code,name,num
from temp
where num>1
open cur_devide
fetch next from cur_devide into @code,@name,@num
while @@fetch_status = 0
begin
set @i=0
while @i<@num
begin
insert into #temp values(@code,@name,1)
set @i = @i + 1
end
fetch next from cur_devide into @code,@name,@num
end
close cur_devide
deallocate cur_devideselect * from #temp order by code