I was hoping no one will ask.

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...