Could be something like this:SELECT
*,
CASE
WHEN Datt < '2009/03' THEN 0
WHEN Datt = '2009/03' THEN
SUM(CASE WHEN Datt <= '2009/03' THEN Amt ELSE 0 END)
OVER (PARTITION BY id)
ELSE Amt
END
FROM
YourTable
If Datt is a date, you should use a date/datetime type. IN the query above, I am assuming it is a string because it seemed so.
Sum Value with Comparison Month/Year from 2 Date
Posted - 11/14/2012 : 04:45:50
