So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?

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, let's say I'm updating 100 rows in a ...