DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0154/2021/TTr-0690604') SET @DATE='2021-05-28 12:00:00 AM' UPDATE PL_REQUEST_DOC SET REQ_DT =@DATE, APPROVE_DT =@DATE, EFFEC_DT =@DATE WHERE REQ_ID =@REQ_ID UPDATE PL_REQUEST_PROCESS SET APPROVE_DT =@DATE WHERE REQ_ID =@REQ_ID --- UPDATE NOI DUNG TAI CHINH 202179