It would be vastly easier to use a non-temp table, even if you create it in the tempdb db.
The difficulty with a temp table is that a temp table created in dynamic SQL would be automatically deallocated
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…