I have a staging table which is loaded daily from a file.
I need to compare this staging table with present final table and
check for differences in columns and update final table and create an audit trail for changes
and generate a excel from sql server.
Is this possible? if yes can someone point me to guide/articles which would help me