brstowe wrote:

> How can I use multiple tables, or indeed process HUGE procedures,
> with
> dynamic table names, or temporary tables?

Isn't this your answer right here? Just CREATE TABLE #foo instead
of CREATE TABLE foo, etc. and each process will get their own local
version of the #foo table.