As a side note, you can join the inserted and deleted tables on your key to get all the values need in a single query.