Project

General

Profile

Download (439 Bytes)

2.4 LUI NGAY PYCMS THEO YEU CAU.txt

Luc Tran Van, 10/04/2021 04:53 PM

 
1 
DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME
2 
SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000917')
3 
SET @DATE='2021-05-25 12:00:00 AM'
4 
UPDATE PL_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID
5 
INSERT INTO PL_PROCESS (REQ_ID,PROCESS_ID,NOTES,PROCESS_DESC,CHECKER_ID,APPROVE_DT)
6 
VALUES (@REQ_ID,'IT',N'Yêu cầu lùi ngày',N'Hỗ trợ lùi ngày PYCMS theo yêu cầu','phuongvn',GETDATE())
7 
---2021101