Am having a table called products with 4 columns, whenever any new insert or update happens,

column "Product_Name_Expiry" will be udpated with prouduct_Name : Product_expriry_date.

IDProduct_NameProduct_Expiry_Date Product_Name_Expiry

-------------------------------------- ---------------------------------

1001Veh2012-08-20 00:00:00.000 Veh: 2012-08-20 00:00:00.000

1075STL2012-08-20 00:00:00.000 STL: 2012-08-20 00:00:00.000

1081TKL2012-08-20 00:00:00.000 TKL: 2012-08-20 00:00:00.000

1569JKT2012-08-20 00:00:00.000 JKT: 2012-08-20 00:00:00.000

1012Veh2012-08-20 00:00:00.000 NULL

1013STL2012-08-20 00:00:00.000 NULL

1014TKL2012-08-20 00:00:00.000 NULL

1515JKT2012-08-20 00:00:00.000 NULL

ID : 1001, 1075, 1081,1569 are the new inserted / updated records, hence trigger fired and product_name_expriry,

My requirement i want to udpate proudct_name_expiry is without updating existing records "1012,1013,1014,1015"

i want a one time stored procedure to udpate existing records.