>Fabio,
>
>>... it Will have to exist ????
>
>Yes, why on earth would you want to insert into something that doesn't exist? Since you didn't do a create table command inside the SP I was assuming it had been created by the caller and will be populated by the called SP.

But this is not possible with a #temptable.

>
>Are you intending to create the #temptable inside the test1 SP? If so it'll go out of scope and disappear once the execution of test1 finishes so there's no point to your code as posted. If you issue a create table #temptable inside the SP and insert into it like my code does it'll work fine.
>

This is not the problem.

I want write two or more mutal exclusive select ... into #temptable.