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!