分级求和

A                B
20061105           10
20061106           12
20061107           13
20061108           14
20061109           15

表是这样的格式
算出每个日期之前的所有的B的值，所得结果如下

   A                B
20061105           10
20061106           22
20061107           35
20061108           49
20061109           64

--------------------------------------------------------------

创建表：create table Test (A char(8),B int)
插入数据：insert into Test4 values ('20061105',10)
          insert into Test4 values ('20061106',12)
          insert into Test4 values ('20061107',13)
          insert into Test4 values ('20061108',14)
          insert into Test4 values ('20061109',15)
SQL语句：select A,B=(select sum(B) from Test where A<=t.A) from Test as t