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

DECLARE @REQ_PAY_ID VARCHAR(20)

SET @REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = 'NBO.2022.000387')

SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = 'NBO.2022.000387'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_PAY_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID = @REQ_PAY_ID

/*

UPDATE TR_REQ_ADVANCE_PAYMENT SET PROCESS = '0' WHERE REQ_PAY_CODE = 'NBO.2022.000387'

UPDATE PL_REQUEST_PROCESS SET PROCESS_iID = '0' WHERE 1=2

UPDATE PL_REQUEST_PROCESS SET PROCESS_ID = '0' WHERE 1=2

*/