I have a table with historic data where I need to set flags in load script if certain conditions are fulfilled.
Date
Action
03/01-2011
REJUR
06/01-2011
AS
09/01-2011
COME
15/01-2011
READV
I need to set flag here because REJUR is above and REJUR date >01/01-2011
16/01-2011
REFGD
I need to set flag here because REJUR is above and REJUR date >01/01-2011
My problem is that there can be 0, 1, 2, 3, ….. 999 actions between REJUR and the other RE* and I need to flag the RE* if REJUR is above and REJUR date is greater than 01/01-2011.
