I'm looking for a bit of strategic input from the community please...
I have a magazine subscription database and a key part of the system is going to revolve around contacting people who have let a subscription expire and getting them to renew their subscription.
What I need to do is run a query at a given point in time that will give me all the Customer IDs for the customers who have let a subscription expire. The result set is saved in a MagazineMailing table as a list of IDs and is used to export the customer data to send a letter out to them.
Two weeks later I need to run another query to tell me which of the original customers still haven't renewed their subscriptions.
I don't have a problem with the queries but my question is this...
What would be the best way to initiate the follow up query? I was thinking of creating and storing a list of MagazineMailing IDs which would be a list of all the MagazineMailings which haven't yet had that second query performed. Or maybe I run a query that tells me which MagazineMailings I still need to run the second query on?
Any thoughts out there?