You can use a LEFT JOIN, or MERGE. Either should be able to insert only the rows that are missing.

This is rather short since you did not provide DDL and some sample data that you need.

Read about both in the SQL BOL.

Andrew SQLDBA