create table #table(DocDate datetime, Doc_Type int, Doc_ID int, C_ID int,col float, Price float, total float);

insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150101', 1, 1, 10, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150201', 1, 1, -5, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150201', 2, 5, -1, 130);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150201', 0, 1, 2, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150301', 1, 1, -10, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150301', 6, 1, 4, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150401', 0, 1, 2, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150401', 0, 5, 5, 130);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150501', 1, 1, 2, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150601', 1, 1, 4, 120);
insert #table(Doc_ID, DocDate, Doc_Type, C_ID, col, Price) values(1, '20150601', 1, 5, -5, 130);

drop table #table

declare @tot_sum  float;
declare @dateinv datetime;

set @tot_sum = 0

;with t AS 
(select #table.*, (select MAX(DocDate) from #table as table1 where DocDate<=#table.DocDate and Doc_Type=0 ) as D_inv
from #table)

select * into #table2
from t

update #table2 set @tot_sum = total = case when @dateinv=D_inv then @tot_sum + ISNULL(Col, 0) ELSE COL END, @dateinv=D_inv

select * from #table2 
 
drop table #table2

select Doc_ID, DocDate, Doc_Type, C_ID, col, Price, 
sum(col) over(partition by GroupNum order by DocDate, Doc_Id ) Total
from 
(
	select Doc_ID, DocDate, Doc_Type, C_ID, col, Price, 
	sum(case when Doc_Type=0 then 1 else 0 end) over(order by DocDate, Doc_Id) GroupNum 
	from #table
) Q

with Q as (	select Doc_ID, DocDate, Doc_Type, C_ID, col, Price, 
	(select count(1) from #table tv 
		where tv.DocDate<=tq.DocDate and tv.Doc_ID<=tq.Doc_ID and tv.Doc_Type=0) GroupNum 
	from #table tq)
	
select Doc_ID, DocDate, Doc_Type, C_ID, col, Price, GroupNum,
(select SUM(col) from Q q2
		where q2.DocDate<=q1.DocDate and q2.Doc_ID<=q1.Doc_ID and q2.GroupNum=q1.GroupNum) Total
from 
Q q1