I do not have the permissions to use tempdb.dbo.* for table name but # works. ANy work around it so that multiple sessions can use the temp table created.

Nikhil.

Thank you. Appreciate your help.