No one has followed this question yet.
You executed this command to create a temporary table: (inside) What is true about the rows inserted into the REPORT_WORK_AREA table during a transaction after commit?
SQL UPDATE PERFOMANCE IMPROVEMENT ??
How to transform vertical table into horizontal table?
Temp Table v/s Permanent table for temporary process?
Issue in Ms2016 : In Identity Column of #Table while 'INSERT INTO EXEC SP' Statement