SQL - Suma Filas

create table #t ( ord int primary key, total int, running_total int)

insert #t(ord,total, running_total)  values (2,20,5)

-- notice the malicious re-ordering

insert #t(ord,total, running_total) values (1,10, 10)

insert #t(ord,total, running_total)  values (3,10, -15)

insert #t(ord,total, running_total)  values (7,1, 20)

insert #t(ord,total, running_total)  values (9,1, -10)

insert #t(ord,total, running_total)  values (11,1, -5)

insert #t(ord,total, running_total)  values (10,1, 20)

--select * from #t

select ord,

       total,

running_total,

       sum(running_total) over(order by ord rows unbounded preceding) as runningtotal

from #t

CREATE TABLE #MiTabla(

Fecha smalldatetime,

Pedido smallint,

SaldoAnterior smallint,

Ingreso smallint,

Egreso smallint,

Saldo smallint

)

go

INSERT INTO #MiTabla VALUES('2013-05-02 02:15:00',899,0,167,0,0)

INSERT INTO #MiTabla VALUES('2013-05-03 16:07:10',900,0,167,0,0)

INSERT INTO #MiTabla VALUES('2013-07-01 13:25:15',901,0,50,0,0)

INSERT INTO #MiTabla VALUES('2013-07-01 22:05:52',902,0,0,140,0)

INSERT INTO #MiTabla VALUES('2014-01-01 23:00:00',500,0,0,1000,0)

-- SS 2012

SELECT

	Fecha,

	ISNULL(

	SUM(ingreso - egreso) OVER(

	ORDER BY Fecha

	ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING

	), 0) AS saldo_anterior,

	ingreso,

	egreso,

	SUM(ingreso - egreso) OVER(

	ORDER BY Fecha

	ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

	) AS saldo

FROM

	#MiTabla

ORDER BY

	Fecha;

GO