>If you know the exact structure beforehand, you can create the temp table first and then insert into that temp table from the SQL EXEC. The temp table should be in scope then,
>
>Else, you might want to create a regular table and dop it when you're done with it.

We considered that. We would like to avoid creating the structure before the process.