Case#, Curr_Status, Status_History
1 90 10,15,20,30,36,90
2 90 10,20,30,42,90
3 90 10,15,20,90
4 30 10,30
90 = Closed
Attempting to return all in Status 90, but only if they have ever been in status 30.
I would expect to return only Case # 1, and 2 (since 3 was never in status 30, and obviously 4 is not in 90.)
If i have understood this correctly;
i think , you would just be able to do a simple set analysis, without any date modifiers and specifying what the specific status is as a modifier. a DISTINCT of the count should give you the number of unique cases, that has ever had a the specific status.