--> 测试数据:[test](转)
if object_id('[test]') is not null drop table [test]go
create table [test]([ID] int,[商品名称] varchar(4),[数量] int,[累加值] int)
insert [test]
select 1,'牙刷',2,null union all
select 2,'脸盆',3,null union all
select 3,'鞋子',3,null union all
select 4,'衣服',2,null
go
;with t
as(
select
a.id,
(select sum([数量]) from test b where b.id<=a.ID) as [累加值]
from
test a
)
update test
set [累加值]=t.[累加值] from t where test.ID=t.ID
select * from test
---------自己按日期的测试
if object_id('[tb]') is not null drop table [tb]
create table [tb] (col numeric(18,2),col2 datetime)
insert into [tb]
select 2,'2013-12-01' union all
select 3,'2013-12-02' union all
select 4,'2013-12-03' union all
select 5,'2013-12-04' union all
select 6,'2013-12-05'
select col2,(
select sum(a.col)as col
from tb a
where a.col2<=b.col2)as col
from tb b