Sequentially Adding Variable Number of Rows

Question

Post reply

Sequentially Adding Variable Number of Rows

roong

SSC Enthusiast

Points: 125
More actions
January 25, 2021 at 5:42 pm
Go to Answer
#3837278

I need to add a number rows together and I'm not sure how to do it.
I have the following dataset.
I want to add the previous rows together to get the following.
Can this be done?

Jeffrey Williams

SSC Guru

Points: 90303

January 25, 2021 at 6:28 pm

Answer

#3837295

 --==== Sample data
Declare @testTable Table (Category char(1), [Month] int, Amount int);
 Insert Into @testTable (Category, [Month], Amount)
 Values ('A', 1, 5)
      , ('A', 2, 5)
      , ('A', 3, 10)
      , ('B', 1, 10)
      , ('B', 2, 10)
      , ('B', 3, 10)
      , ('B', 4, 15);

 --==== Example using sample data
 Select *
      , TotalAmount = sum(tt.Amount) over(Partition By tt.Category Order By tt.[Month] rows unbounded preceding)
   From @testTable tt;

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs