temp tables

N

Newbie

Is it possible to base a report on a temp table created in SQL during the
session?
the temp table name would change each time as it has the SPID(?) added to
the name.

If this is possible could someone give me a clue

Thanks
 
S

Sylvain Lafontaine

Selecting from the temp table didn't work?

Also, as you are using a temporary table, there is no need to change its
name with SPID: temporary table are unique to each connection; with the
exception of global temporary tables (those with two ## instead of a single
#).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top