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.

Learn how to use the SQL subselect statement and handle your database like a pro! ... SQL Basics: SELECT statement options—covers the SELECT statement in detail and explains aggregate functions.