My only concern is the time and logging involved in writing a large amount of items to the temp. table although I have used this technique multiple times. Usually the stored procedure accepts an XML document containing the items of interest. The XML is despooled into a table variable which is referenced by the query.

You could profile both techniques but you'd have to try numerous items.

-Mike