Thanks,

I am new on sql server. Any suggestions would be helpful for me to rewrite this trigger.

Could you please help me on this?

My primary key for table is erp_id and service_contract_number. I have added the erp_id in order by clause. but my top records shows wrong.

e.g. Top records by customer with...