Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

What the best way to work around this? I have the same SELECT statement but there are different criteria depending on the IF check.
Ars Technica

SQL Server 2005: Continue statement on error (Resume on Next)

Is there any way to make a single SQL Statement in a Stored Proc continue after an error is raised by the system? For example ...