If you create a table with # in a session, it will be created in tempdb.
Further, it will be unique for each session.  Once the session is over,
table will be automtically dropped.

If a # table is used in a stored procudure, once the execution of
procedure is over, the table goes out of scope, and will be dropped
automaticaly by the system.

If you want to have a result set, you can just give a select * from
#table at the end, then terminate the procedure, the calling program
will get the result set, but still the table will be dropped
automatically.

Ajit Kumar L

-----Original Message-----
From: William Markham [mailto:William.Markham@p...]
Sent: Saturday, October 13, 2001 5:11 AM
To: sql language
Subject: [sql_language] Re: Passing derived tables to procedures....


another quickie... What does creating a table with # accomplish?  I
notice
I can't find it but it says its there.  does this thing have a limited
existance or do I have to drop it myself??