CREATE PROCEDURE dbo.test1 @choice bit = 0 as if @choice=0 insert into #temptable SELECT 1 x else insert into #temptable SELECT 0 x>Someone knows an setting in order to jump this stupid error,
>CREATE PROCEDURE dbo.test1 > @choice bit = 0 >as > if @choice=0 > SELECT 1 x INTO #TEMPTABLE > else > SELECT 0 x INTO #TEMPTABLE >