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?
What would be the best query to get requested output?
Are table variables only stored in memory
how to improve performance of a LIKE clause?