Query Logic

Hi All,

We've got this data:

FLAG DATE MEMBER_ID
-- --------- -----------
A 12-SEP-08 1072604574
 I 03-DEC-07 1072604574
A 09-MAR-07 1072604574 What we want to do is the increment seperate counters for each month in which the member was active, shows by the letter A.

This data shows that the customer was active on 9/9/07. He inactivated himself on 12/3/07. Then, he reactivted himself on 9/12/08.

So, we want to have seperate counters for the months the member was active, which means March/07 thru November /07, then again on Septermber/08.

Not sure how to actually catch the months between the time he activated and inactivated. Trying a bunch of IF/ELSE statements, but that is getting just too crazy to code.......

Any thoughts on this? Even tried a loop for each month, but even that does not work because even though there is no entry, he was active in May of 07........

Much Regard Received on Tue Sep 16 2008 - 14:29:58 CDT