All Questions
Tagged with surrogate-key upsert
1 question
0
votes
1
answer
509
views
Insert results from query, update old existing row if query doesn't still return same value
I am trying to refactor a table which contains historical data and therefore isn't ever deleted, but has an 'active' field.
Each day we run a query (a few joins, but quite slow) to get some data to ...
- 205