temp tables

  • Thread starter Thread starter Newbie
  • Start date Start date
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
 
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
#).
 
Back
Top