By looking at the code again, I see it really just updated the inserted.row, not for all, so it is not too bad.
Each time we talked about trigger there will be a debate. My front end developer seems like trigger more than DBA likes. They want some constraints done in database like trigger.
thanks,