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.

select into won't work, as it requires that the table not exist so it can create it.<BR><BR>However, insert into #Results select ... will work, and is probably what you want to use.