SELECT 1 x INTO #TEMPTABLE WHERE 1=2 if @choice=0 INSERT INTO #TEMPTABLE SELECT 1 else INSERT INTO #TEMPTABLE SELECT 0>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 >