SQL Server: Inserting a list of ints into a temporary table

Question

I have a list of IDs in a text file like this:

24641985 ,
24641980 ,
24641979 ,
24641978 ,
24641976 ,
24641974 ,
...
...
24641972 ,
24641971 ,
24641970 ,
24641968 ,
24641965)

There's tens of thousands of them.

Now I need to know which ids are in this list, that do not correspond to an ID in my table.

I guess I should put them into a temporary table, then say something like:

select theId 
  from #tempIdCollection
 where theId not in (select customerId from customers)

Problem is I don't know how to get them into the temp table!

Can anyone help? This doesn't have to be efficient. I've just got to run it once. Any solution suggestions welcome!

Thanks in advance!

-Ev

Answer 1

I'd use a table variable. You declare it just like a regular variable.

declare @tempThings table (items int)
insert @tempThings values (1)