I recall once threating to kick the stuffing out of someone who was tasked to fix an instead of trigger that he had written to assume only one row and "fixed" it by including a while loop; but it was spotted in a desk check, before it ever caused a problem, and I hadn't realised there would be 1 row affected messages each time round the loop inside the trigger.