I just ran into an old article - it seems to be the 'holy grail' (or at least a piece of it) regarding tebp table creation ...

https://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/