Posted by brstowe on 10/08/07 09:01

On Oct 5, 7:07 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> 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.

please be honest and tell me if I have completely misunderstood...?
the temporary tables are session/process/user specific...

two users could essentially create/drop tables, and populate/delete
information from tables with exactly the name e.g. #temptable1 at
exactly the same time?

thanks

[Back to original message]