The Silent Bug I Find in Most Triggers

https://www.brentozar.com/archive/2019/05/the-silent-bug-i-find-in-most-triggers/

Addresses multiple row updates in triggers