• That would probably work.  However, I am not sure what happens if the SP were called again before the first call could finish executing.  This SP is called from a web page and my concern is that before the contents of the table could be cleared after we are done processing the request, the SP could be called again.

    Is that a valid concern or am I off in my understanding of SP execution within SQL server?

    Thanks again