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



-- update

DECLARE @REQ_PAY_ID VARCHAR(20) = (SELECT TOP 1 REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = '012023/000570')

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 = 'M1', yeaR_RATE = '2023', budgeT_TYPE = 'nam', BRANCH_KIND = 'Y', BRANCH_TAKE_COST_ID = BRANCH_ID where budG_ID = 'TRBG00000425294'

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(N'BYDT00000000319',N'GOO000001061929',N'BRN000000000388',

N'',N'2023',3000000,0,0,0,0,0,0,0,0,0,0,0,N'ngantvk',N'Feb 14 2023 4:28PM',N'1',N'A',NULL,NULL,

N'TRPY00000248411',NULL,N'',N'',N'Y')

*/