sql游标

insert into @temp 
select items='入庫面積 (SF)',type='每日',dt,rukusf from @ruku 
 
declare @i int,@j int,@dt datetime 
select @i=0,@j=0 
declare c cursor for select dt from @ruku order by dt 
open c 
fetch next from c into @dt  
while @@fetch_status=0 
begin 
select @i=@i+rukusf from @ruku where dt=@dt 
select @j=@j+rukumoney from @ruku where dt=@dt 
insert into @temp 
select items='入庫面積 (SF)',type='累計',@dt,@i 
insert into @temp 
select items='入庫金額 (USD)',type='累計',@dt,@j 
fetch next from c into @dt 
end  
close c 
deallocate c