title: SQL Server - simple discard of duplicate keys/ rows when inserting
body: <p>I'm feeding data into SQL Server database and 1 out of every 1000 records is a duplicate due to matters outside my control. It's an exact duplicate - the entire record, the unique identifier -- everything.</p>
  
  <p>I know this can solved with an 'updated' rather than insert step ... or 'on error, update' instead of insert, perhaps.</p>
  
  <p>But is there a quick and easy way to make SQL Server ignore these duplicates? I haven't made an index/ unique constraint yet -- but if I did that, I don't want a 'duplicate' key value breaking or interrupting the ETL/ data flow process. I just SQL Server to keep executing the insert query. Is there a way to do this?</p>