--累计求总数,并将它做为一字段 CREATE PROCEDURE dbo.CountTotalAsField AS declare @date varchar(20),@product1 int,@total int declare @re table(mydate varchar(20),myproduct1 int,mytotal int set @total=0 DECLARE cursor1 CURSOR FOR select * from table1 open cursor1 FETCH NEXT FROM cursor1 INTO @date,@product1 WHILE @@FETCH_STATUS = 0 begin set @total=@total+@product1 insert @re select @date,@product1,@total FETCH NEXT FROM cursor1 INTO @date,@product1 end CLOSE cursor1 DEALLOCATE cursor1
注意product1字段的类型,要是数字的哦
CREATE PROCEDURE dbo.CountTotalAsField AS
declare @date varchar(20),@product1 int,@total int
declare @re table(mydate varchar(20),myproduct1 int,mytotal int
set @total=0
DECLARE cursor1 CURSOR FOR
select * from table1
open cursor1
FETCH NEXT FROM cursor1 INTO @date,@product1
WHILE @@FETCH_STATUS = 0
begin
set @total=@total+@product1
insert @re select @date,@product1,@total
FETCH NEXT FROM cursor1 INTO @date,@product1
end CLOSE cursor1
DEALLOCATE cursor1
select * from @re
go