I am trying to update an application with the data stored within a number of SQL table nightly. I would only update the row that has changes.
My plan is to use a select statement to query the data I need and store in a temporary table,
Next day I will create another table with the same select statement.
I will then compare and extract the rows that are difference.
Is this a good way to do it?
Can someone guide me what I need to do to achieve this? Thanks.