MSSQL 2008: Delete rows that exist then insert new ones.
hi all. I need to compare source_table with target_table. if target table has same rows as source then delete the those rows from target, and then insert the new rows from source into target. What is the best way to do this? I tried merge but I am having issues.