SELECT * INTO #TEMPTABLE FROM (SELECT 1 x WHERE @choice=0 UNION ALL SELECT 0 x WHERE @choice<>0) dt1