I basically have the same question posed here - Optimal way to ignore duplicate inserts? - except in my case it's SQL Server.
I have a table that is a list of person IDs who are deceased. There are many places in the source database that a person can be indicated as deceased. I would like to do INSERTS from each of these locations into this main table, but a person may be indicated as deceased in multiple places.
Ideally (I think) I just want to ignore duplicate key errors - in the most efficient way possible. (Thus I don't want to have to check the main table for the IDs as part of my INSERT statement.)
(related to solving my question need suggestions to improve view performance)