But since you did. I thought I cannot update a table inside the trigger for which trigger is created. When Sergey said this is the only place... well lets say I felt dumb.
I'm a SQL instructor - there is NEVER a dumb question. The only bad question is the one that goes unasked or unanswered.
The good news is that you CAN do it. I'm posted a code sample in just a moment...