I am a SQL student, mostly self-taught, hence all the misleading ideas. Thank you for your support.

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