Dear David,

Yes I substitute 41 with each item current stock. Below is my original query:

WITH Age ([ItemCode],A,B,C,D) AS (

SELECT [ItemCode],

SUM(CASE WHEN DateDiff(day,DateRecd,GetDate()) BETWEEN 0 AND 30 THEN QtyRecvd ELSE...

Dear David!

Thanks for great support.

This really help for me. Just one confusion for following line:

CASE WHEN A+B > 41 THEN (41-A) ELSE B END AS B

for...