Need to Generate the columns value based on the Previous row

Question

Please look at this picture, All the required formula has been mentioned below the columns.

for better clarity my request is...

Column Name "E" : Item open in current month + historical open items (Previous months Sum)

Column Name "F" Warehouse : open items - closed items.

Need of SQL query.. Thanks in advance !

enter image description here

score -1 · Answer 1 · edited May 23 '17 at 11:57

-1

Take a look at these SQL Server built-in functions.

This post has an example for previous value in SQL Server 2005 and 2012 (this one uses LAG function). How to get previous and current row value using recursive CTE?

edited May 23 '17 at 11:57

Community

answered Apr 05 '15 at 21:40

EternalLearner

They don't do running totals and aren't available in 2008. – Martin Smith Apr 05 '15 at 21:43
Hi @eternal This is not only about previous value. we have some agg function involved and again its not in 2012. Thank you for you participation. – SQLMike Apr 05 '15 at 21:58

1 Answers1