temp tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newbie - 15 Dec 2005 10:24 GMT

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

Reply to this Message

Sylvain Lafontaine - 15 Dec 2005 16:40 GMT

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
#).

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Is it possible to base a report on a temp table created in SQL during the
> session?
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message