SQL Server insert if not exists best practice - Stack Overflow

Another option is to left join your Results table with your exisiting competitors Table and find the new competitors by filtering the distinct records that don´t match int the join: INSERT Competitors (cName) SELECT DISTINCT cr.Name FROM CompResults cr le

stackoverflow.com