Thank you very much..its giving me desired result.:)

Hi Gail,

Thanks for the reply.

I know that the above trigger will fire after insert action to the sometable and insert the records to someothertable.

You used the statement

Select somecolumn from inserted.

What...

The trigger should insert records into tables.

I need only general examples.

Thanks a lot. Both replies helped me a lot to get clear undersatnding.