>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
Yes! XML will be great solution. Why hadn't you propose it to Kevin? This is very ingenious idea.
Venelina Jordanova
Outsourcing IT Services Ltd.