There's no difference how you create temp table and you can add more columns to select
>Hmmm, googled a bit and it seems you can in fact do this,and the 1=0 would give you a blank one.
>
>Doesn't log. Somehow missed that trick as I always create the # tables manually. Is there a downside besides the logging for rollback and can the result then be treated like any # table that is created with an explicit statement as below? And can one also add defined columns not int he original table in the select statement ( cast(0 as bit) foo ) ?
>
>
>
--sb--