DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

-- 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)

*/