>Fabio,
>
>I'm not exactly sure what you are calling a bug here, there's nothing conditional about the temp table itself, it will have to exist in the context of the calling SP for the code below to work at all.
David,
... it Will have to exist ????
With two different names the sp go into the db,
with the same name SQL fire a error:
CREATE PROCEDURE dbo.test1
@choice bit = 0
as
if @choice=0
SELECT 1 x INTO #TEMPTABLE
else
SELECT 0 x INTO #TEMPTABLE1
> But anyway this code compiles and executes without error:
>
>
>CREATE PROCEDURE dbo.test1
> @choice bit = 0
>as
> if @choice=0
> insert into #temptable SELECT 1 x
> else
> insert into #temptable SELECT 0 x
>
>