Fabio,
>But this is not possible with a #temptable.
Yes it is, we have code that does this all the time. Given the code I posted earlier:
create table #temptable ( x int )
exec dbo.test1
select * from #temptable
>I want write two or more mutal exclusive select ... into #temptable.
Then write two or more create table commands.