Only load eventdates less then maxdate for each post, loop?

[#1]

Hi

I have a table with a field of eventdates (diffrent dates for diffrent persons) and a field of maxdate (also diffrent for diffrent persons). I want to only load those eventdates that occurs between min(eventdates) (that field also exist) and the maxdate for each person.

Should I use some sort of loop trought each persons eventdates against the persons maxdate or how to solve it?

I would also like to flag the second eventdate for each person.

Any suggestions are mostly appriated. Thank!

I have attached a qvd with sample data.

[Gysbert_Wassenaar]

Data:
LOAD EventDates,
    Id,
    MaxDate2,
    MinDate_EventDate
FROM  [comm121914.qvd] (qvd)
where EventDates < MaxDate2 and EventDates > MinDate_EventDate;