Here is a table structure and sample data

Create TABLE Test1
(ID int,
 Value1 int)

INSERT INTO Test1 VALUES(1,600);
INSERT INTO Test1 VALUES(2,250);
INSERT INTO Test1 VALUES(3,200);
INSERT INTO Test1 VALUES(4,150);

But I need output like

ID Value1 Cumulative_Value
1 600 600
2 250 850
3 200 1050
4 150 1200

   I need a query for this...

Thanks in advance

How many rows are you talking about? It's important...

--Jeff Moden

Query for n number of rows or atleast 5 rows

Not exactly the estimate I was looking for... there's a huge difference between "N" rows and "at least 5 rows".

First example in the following article a very simple, classic method for running totals and running counts... it's also slow as hell for larger numbers of rows and the article explains why... (first piece of code is the example)...

http://www.sqlservercentral.com/articles/T-SQL/61539/

... and here's the article if you actually want some performance out of it...

http://www.sqlservercentral.com/arti...uerying/61716/

--Jeff Moden