Tom Garth (3/14/2008)
Keep in mind that if just 1 row meets your criteria, you will be undoing the entire update.
Along those lines - if you want the "valid" ones to go through and just not update the others - the easiest way to do that would be to turn this into a INSTEAD OF Trigger instead. That way you can selectively push updates in.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?