Oooh, a GOTO, haven't seen one of those in a while 😀
What else is going on in the TRIGGER? code?
And can you post the tables and all indexes of the tables involved in the deadlock?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato