I need an Update Trigger that only changes data conditionally.
So basically here's the logic. If a row is updated the trigger fires. Then there should be t-sql that says "If I'm the MAX Row for this specific ID, change the values in Table y". I know how to do everything but the "if I'm the Max Row". Meaning that I don't know how to add "complex" logic to a trigger