mardi 5 juillet 2016

How to compare a query to a table in sql


I have queries that finds people that are subscribed, and inserts their emails into a table. To update this, it always truncates the table and inserts all records in it again. Now I want this to not truncate and insert all the data each time (takes a long time for very large records), but do the selection and check with the old table if there was a change, and only add/remove those few records to the table.

Any Idea how would I approach this solution?


Aucun commentaire:

Enregistrer un commentaire