AnsweredAssumed Answered

Strategy for running SQL query two weeks after an initial query?

Question asked by jurgmay on May 14, 2016
Latest reply on May 15, 2016 by jurgmay

Hi all,


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?