"Julio" <espaillat@hotmail.com> wrote in message
news:%23OYtGh2HEHA.3444@TK2MSFTNGP11.phx.gbl...
> Hello
>
> How can do this
>
> ConsumoID Fecha ClienteID Consumo Total
> 1 01/01/04 1 0 0
> = 0-0 = 0
> 2 01/02/04 1 75 75
> = 75-0 = 75
> 3 01/03/04 1 100 25
=
> 100-75 = 25
> 4 01/01/04 2 0 0
> = 0-0 = 0
> 5 01/02/04 2 60 60
> = 60-0 = 60
> 5 01/03/04 2 80 20
> = 80-60 = 20
>
>
>

"Tenaya" <ct@ct.ct> wrote in message
news:eMbsce3HEHA.2556@TK2MSFTNGP12.phx.gbl...
> Julio,
>
> create table Julio
> (
> ConsumoID int NOT NULL primary key,
> Fecha smalldatetime NOT NULL,
> ClienteID int NOT NULL,
> Consumo int NOT NULL,
> Total int NOT NULL default (0)
> )
> go
>
> set dateformat mdy
> insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (1,
> '01/01/04', 1, 0)
> insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (2,
> '01/02/04', 1, 75)
> insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (3,
> '01/03/04', 1, 100)
> insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (4,
> '01/01/04', 2, 0)
> insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (5,
> '01/02/04', 2, 60)
> insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (6,
> '01/03/04', 2, 80)
>
> update Julio
> set Total = Consumo - (select IsNull(sum(j1.Consumo), 0)
> from Julio as j1
> where j1.ConsumoID < Julio.ConsumoID
> and j1.ClienteID =
Julio.ClienteID)
>
> select ConsumoID, Total
> from Julio
> order by ConsumoID
>
> Chief Tenaya
>
>
> "Julio" <espaillat@hotmail.com> wrote in message
> news:%23OYtGh2HEHA.3444@TK2MSFTNGP11.phx.gbl...
> > Hello
> >
> > How can do this
> >
> > ConsumoID Fecha ClienteID Consumo Total
> > 1 01/01/04 1 0 0
> > = 0-0 = 0
> > 2 01/02/04 1 75 75
> > = 75-0 = 75
> > 3 01/03/04 1 100 25
> =
> > 100-75 = 25
> > 4 01/01/04 2 0
0
> > = 0-0 = 0
> > 5 01/02/04 2 60 60
> > = 60-0 = 60
> > 5 01/03/04 2 80 20
> > = 80-60 = 20
> >
> >
> >
>
>

"Tenaya" <ct@ct.ct> wrote in message
news:OtiOej3HEHA.3820@tk2msftngp13.phx.gbl...
> Julio,
>
> P.S. I have assumed that you meant the last row of data to have ConsumoID
=
> 6 rather than 5.
>
> Chief Tenaya
>
>
> "Tenaya" <ct@ct.ct> wrote in message
> news:eMbsce3HEHA.2556@TK2MSFTNGP12.phx.gbl...
> > Julio,
> >
> > create table Julio
> > (
> > ConsumoID int NOT NULL primary key,
> > Fecha smalldatetime NOT NULL,
> > ClienteID int NOT NULL,
> > Consumo int NOT NULL,
> > Total int NOT NULL default (0)
> > )
> > go
> >
> > set dateformat mdy
> > insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (1,
> > '01/01/04', 1, 0)
> > insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (2,
> > '01/02/04', 1, 75)
> > insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (3,
> > '01/03/04', 1, 100)
> > insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (4,
> > '01/01/04', 2, 0)
> > insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (5,
> > '01/02/04', 2, 60)
> > insert into Julio (ConsumoID, Fecha, ClienteID, Consumo) values (6,
> > '01/03/04', 2, 80)
> >
> > update Julio
> > set Total = Consumo - (select IsNull(sum(j1.Consumo), 0)
> > from Julio as j1
> > where j1.ConsumoID <
Julio.ConsumoID
> > and j1.ClienteID =
> Julio.ClienteID)
> >
> > select ConsumoID, Total
> > from Julio
> > order by ConsumoID
> >
> > Chief Tenaya
> >
> >
> > "Julio" <espaillat@hotmail.com> wrote in message
> > news:%23OYtGh2HEHA.3444@TK2MSFTNGP11.phx.gbl...
> > > Hello
> > >
> > > How can do this
> > >
> > > ConsumoID Fecha ClienteID Consumo Total
> > > 1 01/01/04 1 0
0
> > > = 0-0 = 0
> > > 2 01/02/04 1 75 75
> > > = 75-0 = 75
> > > 3 01/03/04 1 100 25
> > =
> > > 100-75 = 25
> > > 4 01/01/04 2 0
> 0
> > > = 0-0 = 0
> > > 5 01/02/04 2 60
60
> > > = 60-0 = 60
> > > 5 01/03/04 2 80
20
> > > = 80-60 = 20
> > >
> > >
> > >
> >
> >
>
>
>