I have a SQL Server INSERT sentence like below:
insert into foo( num, a, b ) values
(1, a, b),
(2, a, b),
(9999, a, b);
You can turn this into a SELECT statement to find the rows that do not match.
Assuming that the column
a references the table
other the following will show the values that are not present in the other table:
select * from ( values (1, a, b), (2, a, b), ... (9999, a, b) ) t(num,a,b) where not exists (select 1 from other o where o.id = t.a);
select .. from ( values ) requires SQL Server 2012 or newer - but as you have used that tag, you should be able to use that.