>Yes, I understand the temporary nature of a temp table created inside a stored procedure, but I'm just trying to test the code snippet in QA. The table should persist after execution.

I wasn't clear enough, sorry. The code excuted by EXECUTE statement is a separate batch and the same rule applys to it as to the sproc, any temporary table created is deleted at the end of it.