Project

General

Profile

invoice4.txt

Luc Tran Van, 11/16/2022 06:21 PM

 
1
UPDATE TR_REQ_PAY_INVOICE SET PRICE = PRICE_KT, VAT = VAT_KT WHERE TYPE_FUNC = 'KT'
2

    
3
AND REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE CONVERT(DATE, CREATE_DT_KT,103) <='2022-10-16')