Project

General

Profile

Download (1.13 KB)

5.0 CAP NHAT NOI DUNG THANH TOAN.txt

Luc Tran Van, 03/11/2021 01:33 PM

 
1 
??DECLARE @REQ_ID VARCHAR(15), @REA_REASON NVARCHAR(250)
2 
SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='032021/000644')
3 
SET @REA_REASON =(SELECT REQ_REASON FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='032021/000644')
4
5 
UPDATE TR_REQ_PAY_SCHEDULE SET REQ_PAY_DESC =@REA_REASON, REQ_PAY_ENTRIES = @REA_REASON WHERE REQ_PAY_ID =@REQ_ID
6
7 
UPDATE TR_REQ_PAY_BUDGET SET REASON =@REA_REASON WHERE REQ_PAY_ID =@REQ_ID
8
9 
UPDATE TR_REQ_PAY_METHOD SET REQ_PAY_DESC =@REA_REASON, REQ_PAY_REASON = @REA_REASON, REQ_PAY_ENTRIES = @REA_REASON WHERE REQ_PAY_ID =@REQ_ID