sean i really do get what you mean...let me try to get you more info...

basically the customer information in the customersA table on any given day can have multiple same customer info..

example : Vam is the customer in the sample table i sent..he has multiple rows created by different agents(CreatedBy) because for some reason he has been approached by the same agent for different products but according to the new rule no matter how many products are sold or introduced to a customer he should be only considered once and also a particular customer row is considered active...for only the time frame described in the Parameters Table...

so THE FIRST vam row in this case is active for one day and if any new rows for the same customer have been created in that particular day they are considered inactive and assigned a valid status as '9(NO)'...