Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Temporary Table Created Inside an EXEC Statement

Author  Topic  jaym Starting Member 4 Posts Posted - 2001-03-08 : 09:44:51 Hello, I am using SQL Server 2000 and I can't get to a the data in a LOCAL temp table created inside a dynamic SQL statement executed by an EXEC. I already devised a workaround by using a global temp table (2 #'s infront), the name which had to be dynamically generated to make it unique. I was just wondering if there is another way which is simpler and uses the local temp table. Thanks jaym