I have been reading up on the MERGE syntax in SQL Server and it's perfect for what I need it to do, however I cannot for the life of me figure out how to prevent the target table from deleting old data that I don't want to match against.I have been reading up on the MERGE syntax in S