-- update
--DECLARE @BRANCH_ID VARCHAR(20) = ''
DECLARE @BRANCH_KIND VARCHAR(20) = ''
DECLARE @MONTH_RATE VARCHAR(20) = ''
DECLARE @M1 DECIMAL(18, 0) = 0
DECLARE @M2 DECIMAL(18, 0) = 0
DECLARE @BUDGET_YEAR_LIMIT_DETAIL_ID VARCHAR(20) = N'BYDT00000000320'
DECLARE @REQ_PAY_ID VARCHAR(20) = (SELECT TOP 1 REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = '012023/000570')
DECLARE @MAKER_ID VARCHAR(20) = (SELECT TOP 1 MAKER_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @REQ_PAY_ID)
DECLARE @BRANCH_ID VARCHAR(20) = (SELECT TOP 1 BRANCH_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @REQ_PAY_ID)

SELECT * FROM TR_REQ_PAY_BUDGET where REQ_PAY_ID = @REQ_PAY_ID 
SELECT * FROM TR_REQ_BUDGET_YEAR_LIMIT_DETAIL where REQ_PAY_ID = @REQ_PAY_ID 
/*
update TR_REQ_PAY_BUDGET  set montH_RATE = @MONTH_RATE, yeaR_RATE = '2023', budgeT_TYPE = 'nam', BRANCH_KIND = @BRANCH_KIND, BRANCH_TAKE_COST_ID = BRANCH_ID where budG_ID = 'TRBG00000425294'

update TR_REQ_PAY_BUDGET  set montH_RATE = @MONTH_RATE, yeaR_RATE = '2023', budgeT_TYPE = 'nam', BRANCH_KIND = @BRANCH_KIND, BRANCH_TAKE_COST_ID = BRANCH_ID where REQ_PAY_ID = @REQ_PAY_ID

INSERT INTO [TR_REQ_BUDGET_YEAR_LIMIT_DETAIL] ([BUDGET_YEAR_LIMIT_DETAIL_ID],[GD_ID],[BRANCH_ID],[DEP_ID],[BUDGET_YEAR],
[M1],[M2],[M3],[M4],[M5],[M6],[M7],[M8],[M9],[M10],[M11],[M12],[MAKER_ID],[CREATE_DT],[RECORD_STATUS],[AUTH_STATUS],
[CHECKER_ID],[APPROVE_DT],[REQ_PAY_ID],[KHOI_ID],[TLNAME],[ROLENAME],[BRANCH_KIND])
VALUES(@BUDGET_YEAR_LIMIT_DETAIL_ID ,N'GOO000001061929',@BRANCH_ID, N'',N'2023',
@M1, @M2,0,0,0,0,0,0,0,0,0,0, @MAKER_ID,N'Feb 14 2023 4:28PM',N'1',N'A',
NULL,NULL, @REQ_PAY_ID,NULL,N'',N'', @BRANCH_KIND)
*/