I have a small issue with an AFTER UPDATE Triger I implemented on one table of my db. In my trigger, I do some validation and update others (not in inserted or deleted) rows of my table. Thoses rows are updated but are not triggering my trigger (similar to a controlled loop). I'm wondering if there's a way to get them running the same trigger.
I have a situation of child / parent in my rows sometimes. If I'm updating a child, I need the parent to be updated and validated. A child is not very at all and I really needs the parent to be the one who makes the "call".
Is it feasible?