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?
how to improve performance of a LIKE clause?
Are table variables only stored in memory
Does my temp table necessarily write out to tempdb on disk?