Just Fantastic!!! It worked like a charm.. Thanks Drew....

Another way, which I got from another forum.. thought of sharing with you..

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=160277

Thanks

Sree

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