I'm doing this in a stored proc using SQL Server.<BR><BR>Basically, I'm executing 1 SELECT statement and if that returns any rows then I want to do a SELECT INTO #Temp With criteria A.

create of replace view stuff select id, value1, value2, 1 as type from tab2 union all select id, value1, value2, 2 as type from tab1 where tab1_value1 = "B" and tab1_value2 <> "C" union all ...