第2个回答 2008-06-27
假设原来的表是t1:
declare @t table ([date] int,sale int,[sum] int)
declare @dt int,@sale int,@sum int
declare @c cursor
set @sum=0
set @c=cursor forward_only read_only for select * from t1 order by dt
open @c
fetch next from @c into @dt,@sale
while @@fetch_status=0
begin
set @sum=@sum+@sale
insert @t values (@dt,@sale,@sum)
fetch next from @c into @dt,@sale
end
close @c
deallocate @c
select * from @t
这是用存储过程实现,至于如何用一条语句实现,我想不出来。本回答被提问者采纳