SQL Server - Agregar campo que subtotalice en consulta SQL Server

DROP TABLE #MiTabla

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

DECLARE @Montos TABLE (

  Concepto	CHAR(2),

  Monto		NUMERIC(8, 2)

);

INSERT INTO @Montos(Concepto, Monto) VALUES

('c1', 100),

('c2', -75 ),

('c3', 5);

SELECT M.Concepto

		, M.Monto

		, SUM(M.Monto) OVER (ORDER BY M.Concepto) AS Subtotal

FROM @Montos AS M

ORDER BY M.Concepto;