Data that differ between tables
Hi team!
Could you please tell me how to compare differences between table and my select query and insert those results in separate table? My plan is to create one base table (name RESULT) by using select statement and populate it with current result set from select statement provided down. Then next day I would like to create procedure which will going to compare same select with RESULT table, and insert only results which differ (if I get changes on just one row then I want to catch only that) into another table called DIFFERENCES.
I'm using this query to populate RESULT table: