Thanks again MMartin1.  Both works nicely.

Thanks MMartin1.  That works perfectly.  Is it possible to have a similar one for Update?  I tried to add the Update but it will do the insert whenever update happen.

Thanks Jeff Moden.  Are you saying the following change will avoid self-triggering and double dipping?

CREATE...

thanks palotaiarpad & Thom A. Yes, I was asking if this end up self triggering. I correct the code as follow:

CREATE TRIGGER Mytrigger ON Mytable
AFTER insert, update
AS