Quote Originally Posted by Queyon
I want to create a global temporary table but don't want to get any table name confict.
Read this very interesting article - it answers your question:

http://www.indiana.edu/~dss/Services...s/tmptabl.html