>>The same way you would create it in the stored procedure: by sending SELECT INTO or CREATE TABLE from frontend.
>
>Sorry that I can't get this concept wrapped in my head. Are you saying that I can send (in the same SPT connection) to SQL Server a string that will create a temp table and then a SQL Command string that will use this table in a SQL Select?

A local SQL Server temp table is scoped to the current session. It'll exists until you drop it or close connection. So yes, you can create a temp table and then use it on the same connection.