SQL Server - COMO INSERTAR UN SUMATORIO DE FILAS ORDENADAS POR UN CAMPO

UPDATE tutbla SET tucolumnavacia = x.valor

FROM tutabla inner join (

 Select Numero, Nombre, Calibre,

 Calibre+LAG(Calibre,1,0) over (order by Numero) as Acumulado

 from laTabla) as x

on tutabla.id = x.id

drop table #Tmp

Create Table #Tmp(

Fecha_Hora smalldatetime,

No_Comprobante int,

No_Linea smallint,

Lote int,

Pcb smallint,

Pedido smallint,

Ingreso smallint,

Egreso smallint,

Saldo smallint

)

go

Insert into #Tmp values('2005-05-02 01:15:00',4,1,21,6,334,167,0,0)

Insert into #Tmp values('2005-05-03 15:07:10',5,1,29,6,167,167,0,0)

Insert into #Tmp values('2005-07-01 12:25:15',6,1,12,6,200,50,0,0)

Insert into #Tmp values('2005-07-01 21:05:52',25,1,1,6,200,0,140,0)

Insert into #Tmp values('2005-07-02 21:05:52',25,1,1,6,200,9,0,0)

Insert into #Tmp values('2005-07-03 21:05:52',25,1,1,6,200,0,140,0)

Insert into #Tmp values('2005-07-04 21:05:52',25,1,1,6,200,100,0,0)

Insert into #Tmp values('2005-07-05 21:05:52',25,1,1,6,200,0,150,0)

Insert into #Tmp values('2005-07-06 21:05:52',25,1,1,6,200,20,0,0)

Insert into #Tmp values('2005-07-07 21:05:52',25,1,1,6,200,0,20,0)

Insert into #Tmp values('2005-07-08 21:05:52',25,1,1,6,200,100,0,0)

Insert into #Tmp values('2005-07-09 21:05:52',25,1,1,6,200,0,20,0)

go

select

        a.fecha_hora,

        a.ingreso,

        a.egreso,

        sum(b.ingreso - b.egreso) as saldo

from

        #Tmp as a

        inner join

        #Tmp as b

        on b.Fecha_Hora <= a.Fecha_Hora

group by

        a.fecha_hora,

        a.ingreso,

        a.egreso

order by

        1 asc

go

CREATE TABLE #WACTran(

	[TranOrder]		INT PRIMARY KEY CLUSTERED,

	[TranType]		VARCHAR(3) NULL,

	[Qty]			INT NULL,

	[UnitCost]		DECIMAL(14, 4) NULL,

	[ExtendedCost]	DECIMAL(14, 4) NULL,

	[QtyOnHand]		INT

)

INSERT INTO [#WACTran](TranOrder, TranType, Qty, UnitCost, ExtendedCost)

VALUES

 (0	,'BB',100	,1.5000,	150.0000 )

,(1	,'S',-50	,0.0000,	0.0000	 )

,(2	,'RCT',15	,0.0000,	0.0000	 )

,(3	,'S',-5		,0.0000,	0.0000	 )

,(4	,'VC',15	,1.6000,	0.0000	 )

,(5	,'S',-5		,0.0000,	0.0000	 )

,(6	,'TO',-4	,0.0000,	0.0000	 )

,(7	,'TI',2		,0.0000,	0.0000	 )

,(8	,'VTI',2	,1.6500,	0.0000	 )

,(9	,'RCT',10	,0.0000,	0.0000	 )

,(10,'S',-5		,0.0000,	0.0000	 )

,(11,'VC',10	,1.7500,	0.0000	 )

,(12,'S',-5		,0.0000,	0.0000	 )

,(13,'TO',-4	,0.0000,	0.0000	 )

,(14,'TI',2		,0.0000,	0.0000	 );

--===== Declare some obviously named variables

DECLARE @PrevTranOrder		INT,

        @PrevQtyOnHand		INT,

		@PrevUnitCost		DECIMAL(14,4),

		@PrevExtendedCost	DECIMAL(14,4)

--===== Do the "quirky" update using a very high speed pseudo-cursor,

     -- This is very similar to what you would do in a language like "C" except the

     -- "Read a row/Write a row" is built into the update.

 UPDATE #WACTran

    SET @PrevQtyOnHand = QtyOnHand = CASE

										WHEN TranType = 'BB'

										THEN Qty

										WHEN TranType IN ('VTI','VC')

										THEN @PrevQtyOnHand

										ELSE @PrevQtyOnHand + Qty

									END,

		@PrevUnitCost = UnitCost = CASE

										WHEN TranType = 'BB'

										THEN UnitCost

										WHEN TranType IN ('VTI','VC')

										THEN (((@PrevQtyOnHand - Qty)*@PrevUnitCost)+(Qty*UnitCost))/@PrevQtyOnHand

										ELSE @PrevUnitCost

									END,

		@PrevExtendedCost = ExtendedCost = CASE

										WHEN TranType = 'BB'

										THEN ExtendedCost

										ELSE @PrevUnitCost*@PrevQtyOnHand

									END,

								@PrevTranOrder   = TranOrder --Just an "anchor", but gotta have it to guarantee things.

						   FROM [#WACTran] WITH (INDEX(0), TABLOCKX)

--===== Display the results

 SELECT *

   FROM [#WACTran]

  ORDER BY TranOrder

DROP TABLE #WACTran;

drop table #t 

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