DECLARE @REQ_ID VARCHAR(15), @REASON NVARCHAR(1000) SET @REQ_ID= (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000300') SET @REASON =(SELECT top 1 REQ_REASON FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID =@REQ_ID) UPDATE TR_REQ_PAY_BUDGET SET AMT_APP =251910071, AMT_DO =0, AMT_REMAIN =251910071 WHERE BUDG_ID ='TRBG00000281803' INSERT INTO TR_REQ_PAY_BUDGET(BUDG_ID, GD_ID, REQ_PAY_ID, TRADE_ID, AMT_APP, AMT_DO, AMT_EXE, AMT_REMAIN, MAKER_ID, CREATE_DT, CURRENCY, RATE, REASON, NOTES, TYPE_COST, FR_LEVEL, TO_LEVEL) VALUES ('BUDGID000000002','GOO000000251701',@REQ_ID,'PLT000000260527',68087250,0,0,68087250,'phuongvn',GETDATE(),'VND',1,@REASON,'',NULL,0,0) SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID =@REQ_ID