SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code.

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.