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.

You can set up notifications for SELECT and EXECUTE statements. When using an EXECUTE statement, SQL Server registers a notification for the command executed rather than the EXECUTE statement itself.

BANGALORE, INDIA: In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. MERGE statement allows you to join a data source with a ...