Can't use Temp Tables - really?

Or the parser hack I previously learned in SSIS...

IF 1 = 0

    BEGIN

        SELECT

            'ColumnDefinition1' = CAST(NULL AS DATE), -- columns and data types in your final result set

            'ColumnDefinition2' = CAST(NULL AS NVARCHAR(75)) -- etc.

    END

/* Use temp tables until your heart is content */

/* Finish with a Select using the same definition as you defined in the top section */