temporary tables

[maggie gallotti]

I am using a temporary table as input into a report. This table is based on some queries, so each time the results may be different. It's a little annoying because whenever there are two people wanting to create this report, one can't because the table is already being created by somebody else. I drop it from the database after report is created. How can I create a temporary table with different names each time so that many reports can be created ? I would drop these after creation of reports of course. Does this make sense? Or am I on the wrong track? Thanks for your advice in advance!

[forty7]

Use a timestamp as the name of your temporary table. The chances of two people creating the same table name at the same time are very small if you don't have too many users.

thanx/good luck,
adam