>It is as though creating a temp table on the server through SPT with create Table ##tablename 2 ## means temptable for the user and will go out of scope when the connection ends or the table is specifically droped.
>
>then u can insert records into the temp table through 1)insert command or 2) by making the cursor updatable , later u can use this for the orignal join.....

The ##tablename is global temp table visible to all users. The #tablename is local temp table visible to the particulat session/batch only. See BOL for details.