This is the solution i made to your problem :
CREATE TABLE TEMP (id INT identity(1,1), somedate datetime, somevalue int)
insert into temp values ('01/Jan/09',3)
insert into temp values ('08/Jan/09',5)
insert into temp values ('02/Feb/09',0)
insert into temp values ('14/Feb/09',7)
insert into temp values ('20/Feb/09',34)
insert into temp values ('02/Mar/09',6)
select * from temp
create table #temp (id int, somevalue int)
insert into #temp (id, somevalue)
select id, somevalue from temp
select * from #temp
select t.id , convert(varchar,t.somedate, 106), t.somevalue, SUM(tp.somevalue) from temp t, #temp tp
where t.id >= tp.id
group by t.id , t.somedate, t.somevalue
drop table #temp