Hi all

I have a situation. I have a table of IDs on a local drive. I want SQL Server to return records matching those IDs. There are possibly too many for them to be concatenated into a string. Can I have SQL create a table for a particular user, append these records, use that table in one or more other SPTs and drop that table when I'm done?

If so, can you provide a small example?