SELECT SUM(STOCK_IN - STOCK_OUT) AS AMOUNT ,PRODUCT_ID,PROCESS_DATE,SummAcc
FROM (SELECT *,SUM(STOCK_IN - STOCK_OUT) OVER (PARTITION BY PRODUCT_ID ORDER BY PROCESS_DATE ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS SummAcc
FROM STOCKS_ROW)t
GROUP BY PRODUCT_ID,PROCESS_DATE,SummAcc HAVING PRODUCT_ID= 484

quote:

---

Originally posted by visakh16

SELECT SUM(STOCK_IN - STOCK_OUT) AS AMOUNT ,PRODUCT_ID,PROCESS_DATE,SummAcc
FROM (SELECT *,SUM(STOCK_IN - STOCK_OUT) OVER (PARTITION BY PRODUCT_ID ORDER BY PROCESS_DATE ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS SummAcc
FROM STOCKS_ROW)t
GROUP BY PRODUCT_ID,PROCESS_DATE,SummAcc HAVING PRODUCT_ID= 484

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

;With CTE
AS
(
SELECT SUM(STOCK_IN - STOCK_OUT) AS AMOUNT ,PRODUCT_ID,PROCESS_DATE 
FROM STOCKS_ROW 
GROUP BY PRODUCT_ID,PROCESS_DATE 
HAVING PRODUCT_ID= 484
)

SELECT *
FROM CTE c1
CROSS APPLY (SELECT SUM(AMOUNT) AS CUMMAMOUNT
             FROM CTE
             WHERE PRODUCT_ID = c1.PRODUCT_ID	
             AND PROCESS_DATE < = c1.PROCESS_DATE
            )c2