You need to create the temp table before the first EXEC.
Parent session temp tables are visible in child sessions.
Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design
New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014
No comments:
Post a Comment