I am creating a program in which I create tables to preview reports. I delete the temporary tables after the report is done being viewed/printed. The program is a multi-user program and if it so happens that User A is previewing the report and User B wants to view the same report they would get an error because it tries to create a table with the same name.

I have thought of two options. One would be creating a different name for the table everytime it's created (based on a datetime stamp or something), but the question is how do I refer to it in my create table command?

create table (blah);

The second option is just to lock the table and use some sort of wait window for User B until the program is done, but this is less desirable as the first option.

Any help is greatly appreciated.