Click here to Skip to main content
15,881,757 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have variable Table
declare @Table Table
Value1 float,
Value2 float,
Total float
Insert into @Table values (1,1)
Insert into @Table values (2,2)
Insert into @Table values (3,3)
Insert into @Table values (4,4)
Insert into @Table values (5,5)

i need the total column to be the sum(value1+value2) from the current row +Previous Rows

so the result 'll be like that

Value1 Values Total
1 1 2
2 2 6
3 3 12
4 4 20
5 5 30

so how i can calculate the total
i don't want to use loop because in the real example i have about 2000 rows or more so of i use any loop statement it 'll took too much time
i need to keep the performance good

[code] block updated
Updated 10-Jul-12 18:09pm

Try this:
Calculating simple running totals in SQL Server[^]

Hope this helps,
Share this answer
create trigger trig_product
on table
after insert
declare @input varchar(25)
set @input = (select distinct    max(Total)  from  table)
update  table
	set  Total = @input 
	from  table where ID=(select max(ID) from Table)
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900