Project

General

Profile

Support #212

22092020

Added by Truong Nguyen Vu over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
09/22/2020
Due date:
% Done:

0%

Estimated time:
FILE 1.txt (8.46 KB) FILE 1.txt Truong Nguyen Vu, 09/22/2020 08:17 AM
FILE 2.txt (10.1 KB) FILE 2.txt Truong Nguyen Vu, 09/22/2020 09:39 AM
FILE 3.txt (448 Bytes) FILE 3.txt Truong Nguyen Vu, 09/22/2020 10:43 AM
FILE 5.txt (33.9 KB) FILE 5.txt Truong Nguyen Vu, 09/22/2020 02:34 PM
FILE 6.txt (33.8 KB) FILE 6.txt Truong Nguyen Vu, 09/22/2020 02:40 PM
data1.xlsx (27.5 KB) data1.xlsx Luc Tran Van, 09/22/2020 03:17 PM
FILE 8.txt (2.06 KB) FILE 8.txt Truong Nguyen Vu, 09/22/2020 03:32 PM

History

#2 Updated by Truong Nguyen Vu over 4 years ago

SELECT * FROM dbo.TR_CODE_GEN

WHERE CODE_TYPE='PL_REQUEST_DOC' AND CUR_YEAR='DEP000000000058.2020'

#3 Updated by Truong Nguyen Vu over 4 years ago

SELECT * FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE LIKE '%0690402'

#4 Updated by Truong Nguyen Vu over 4 years ago

INSERT INTO dbo.TR_CODE_GEN
(
CODE_TYPE,
CUR_YEAR,
CUR_VALUE
)
VALUES
( 'PL_REQUEST_DOC', -- CODE_TYPE - varchar(50)
'DEP000000000058.2020', -- CUR_YEAR - varchar(50)
2 -- CUR_VALUE - decimal(18, 0)
)

#6 Updated by Truong Nguyen Vu over 4 years ago

UPDATE dbo.TR_REQUEST_DOC SET DMMS_ID='DMMS00000000001' WHERE REQ_ID=''

#9 Updated by Luc Tran Van over 4 years ago

#11 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF