Hello Good Morning Guru's
Can you please help me to give some ideas or links that I can use it in my situation.
I have two tables, both tables have EMPID as primarykey.
Here DailyStageTable is truncate and get loads daily.where as FinalTable is the main table it has all data only appends no deletion happens in this FinalTable
1) FinalTable (EMPID, Col1,Col2, Col3, Col4, Col5, Col6, Col7, InsertDate, UpdateDate)
2) DailyStageTable (EMPID, Col1,Col2, Col3, Col4, Col5, Col6, Col7)
so here, I have a daily job that executes the procedure, the procedure logic does 2 things
1) insertion of new records from DailyStageTable to FinalTable (based on EMPID) also populates Insertdate (getdate() of procedure execution)
2) updates the remain values Col1,Col2,Col3,Col4,Col5,Col6, Col7 if any of these values were differet between both tables for an EMPID.
so far it looks good, but now I should not allow utomatic updates for Col3, Col6 (using the update statement in procedure) instead I need to alert with the data in it so the update will handle manually by some person..
so here my question is any idea on "ALERT" thsee two columnc changes if any?
what could be best possible ways to do it, this can be an email or stage them in some table or in same table...