Have you looked at using MERGE INTO?

https://msdn.microsoft.com/en-us/library/bb510625(v=sql.110).aspx

The article states, "Performs insert, update, or delete operations on a target table based on the results of a join with a source table."...