• Thanks Micheal and Gsquared for the replies. i really appreciate it.

    GSquared,

    You are right. But the maintenance will be really difficult right. Any change in the table, everybody forgets to update the trigger right. So I am trying to make it as generic as possible. Do you think that will affect the performance badly? Thats why i am tring to avoid the dynamic sql. Performance is ofcourse an important criteria for me. But my manager donot want me to hard code things as well. I dono what is a best solution here.

    Any suggestion is greatly appreciated.