>>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.


Thanx for correcting, infact not use sql server for a long time now ...