数据的累计

--> 测试数据：[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