update finished_item_master set itemopeningvalue = round(purrateperpcs * itemopeningpcs,2) where itemper = 'P' AND itemopeningvalue =0 update finished_item_master set itemopeningvalue = round(purrateperMTS * itemopeningMTS,2) where itemper = 'M' AND itemopeningvalue =0