drop table #t
go 
create table #t(nomer int, summa int, god int)

insert #t(nomer, summa, god) values ( 3 ,	 100 ,	 2007 )
insert #t(nomer, summa, god) values ( 3 ,	 200 ,	 2008 )
insert #t(nomer, summa, god) values ( 6 ,	 500 ,	 2009 )
insert #t(nomer, summa, god) values ( 6 ,	 300 ,	 2010 )
insert #t(nomer, summa, god) values ( 5 ,	 100 ,	 2007 )
insert #t(nomer, summa, god) values ( 5 ,	 300 ,	 2008 )
insert #t(nomer, summa, god) values ( 5 ,	 400 ,	 2010 )

alter table #t add id int null

declare @i int 
set @i =  0  
update #t set id = @i, @i=@i+ 1 


select 
	#t.nomer, 
	#t.summa, 
	#t.god, (select sum(t1.summa) from #t as t1 where #t.id >=t1.id and t1.nomer = #t.nomer)
from #t

nomer  summa    god
3	100	2007	100
3	200	2008	300
6	500	2009	500
6	300	2010	800
5	100	2007	100
5	300	2008	400
5	400	2010	800

select 
	#t.nomer, 
	#t.summa, 
	#t.god, (select sum(t1.summa) from #t as t1 where #t.god >=t1.god and t1.nomer = #t.nomer)
from #t