Project

General

Profile

Support #862

Cập nhật quy cách kĩ thuật PUR/2020/000989

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
01/25/2021
Due date:
% Done:

0%

Estimated time:

Description

DECLARE @REQ_ID VARCHAR, @DATE DATETIME
SET @DATE ='2020-12-14 12:00:00 AM'
SET @REQ_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000989')
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM TR_REQUEST_DOC_dt WHERE REQ_doc_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
--SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC_DT SET DESCRIPTION =N'Bình thủy điện NC - EG3000' WHERE REQDT_ID ='TRRDD0000255673'

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF