Hi Suhas

>I live near Jog Falls (abt 70kms from the place i live)....

That's a beautiful place to live near, great weekends you might be having.

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

Thanks for your help with this. I will try out temp tables and trouble you if I get stuck anywhere.