"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:D79D683A-235C-45EB-934C-7AECB4F2AFE6@microsoft.com...
>> I mean I want to sum a column with previous column..
>> how can I do that?
>
> One method to calculate a running total is with a subquery:
>
> CREATE TABLE dbo.MyTable
> (
> [Code] int NOT NULL
> CONSTRAINT PK_MyTable PRIMARY KEY,
> [Value] int NOT NULL
> )
> INSERT INTO dbo.MyTable
> SELECT 1, 1000
> UNION ALL SELECT 2, 2000
> UNION ALL SELECT 3, -500
> GO
>
> SELECT
> [Code],
> [Value],
> (
> SELECT SUM(Value)
> FROM dbo.MyTable prev
> WHERE
> prev.[Code] <= curr.[Code]
> ) AS Total
> FROM dbo.MyTable curr
> ORDER BY [Code]
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "perspolis" <rezarms@hotmail.com> wrote in message
> news:OAYufahHIHA.284@TK2MSFTNGP02.phx.gbl...
>> Hi all
>> I have a table like this
>> Code Value
>> 1 1000
>> 2 2000
>> 3 -500
>> I want to write a query that returns like following output:
>> Code Value Total
>> 1 1000 1000
>> 2 2000 3000
>> 3 -500 2500
>> I mean I want to sum a column with previous column..
>> how can I do that?
>> thanks in advance
>>
>>
>
>

> I mean I want to sum a column with previous column..
> how can I do that?

"perspolis" <rezarms@hotmail.com> wrote in message
news:OAYufahHIHA.284@TK2MSFTNGP02.phx.gbl...
> Hi all
> I have a table like this
> Code Value
> 1 1000
> 2 2000
> 3 -500
> I want to write a query that returns like following output:
> Code Value Total
> 1 1000 1000
> 2 2000 3000
> 3 -500 2500
> I mean I want to sum a column with previous column..
> how can I do that?
> thanks in advance
>
>