Thank you for the quick reply...

I think, I need a global temp table because I am using EXEC('query') also in the SP to insert to the temp table. If we use EXEC, I think, it will create a local connection again, and so the local temp table will not be available in that session.

Anyway, when I am using local temp table, it is throwing the Invalid object name error in my laptop itself.

Thanks

Sree