• One (additional) way to avoid trigger recursion is using an INSTEAD OF trigger. You probably will have to rewrite your trigger since the original update will not be executed...