UPDATE dbo.TR_CONTRACT_PAYMENT SET [PERCENT] = (AMOUNT/ (SELECT SUM(PRICE * QUANTITY) FROM dbo.TR_CONTRACT_DT WHERE TR_CONTRACT_PAYMENT.CONTRACT_ID=TR_CONTRACT_DT.CONTRACT_ID)) * 100 WHERE TR_CONTRACT_PAYMENT.CONTRACT_ID  IN (SELECT CONTRACT_ID FROM dbo.TR_CONTRACT WHERE MAKER_ID='tuyenlt')