Like I said in my original response:
"Where did the selection list of 'number' column values come from?"
If you have a list of " ... over a thousand numbers to extract from the table..." you don't expect to somehow construct an IN clause that has these thousands of entries in it, do you? How do you intend to do that?
Get it into the database and your query becomes simple. There are any number of ways to import that data into a database table, assuming you have your list of thousands of entries in some kind of rational machine-readable form.
Note that my use of the phrases " ...get it into the database ..." and "..import that data ..." doesn't necessarily mean that the list has to physically reside in a SQL Server database. You can construct what's called a "linked server" which actually refers to, say, an Excel spreadsheet which contains the list of 'numbers'. This link can then function as a database table and be referenced by queries such as the OUTER JOIN I suggested.
Search BOL for 'Excel' and 'linked server' to see how to do that.
Custom Apps, Inc.