具有多个批次的SQL Server存储过程 - 重用临时表

I have a short SQL script which has been in use for a bit. It reuses a temp table within a script and has been working nicely. I have a short SQL script which has been in use