I have a requirement to update fields between a staging table and a master table
So, for example if the value in the staging table differs from the master table update the master table. (eg firstname, lastname, address) The SQL for that would not be complicated.
The question i have is how could i determine if any changes where made? For example if i have an update statement to set master.firstname = staging.firstname is there a way i could return if the update was made vs if they where identical to start with so no change was made.