I have a large data feed each morning that is dumped into a SQL Server table with a truncate query.
I need to update parts of my master table with any changes from this dump and append any new rows (basically the rest) to my Master table also from this dump.
To reduce the run time this truncate query is about to be modified to cover only the last 2 years. SQL server
How should I go about do this
Both tables have identical structure so hopefully this should be fairly straight forward.