Project

General

Profile

UPDATE_PL_REQUEST_PROCESS_CUOGNVD.txt

Truong Nguyen Vu, 08/31/2020 10:48 PM

 
1
UPDATE dbo.PL_REQUEST_PROCESS_CHILD SET PROCESS_ID=(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID=PL_REQUEST_PROCESS.REQ_ID AND PROCESS_ID='DMMS')
2
WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID IN (
3

    
4
SELECT REQ_ID FROM dbo.TR_REQUEST_DOC WHERE REQ_ID iN
5

    
6

    
7
('TRRD00001055532',
8
'TRRD00001055533',
9
'TRRD00001055534',
10
'TRRD00001055535',
11
'TRRD00001055536',
12
'TRRD00001055537',
13
'TRRD00001055538',
14
'TRRD00001055539',
15
'TRRD00001055540',
16
'TRRD00001055541',
17
'TRRD00001055542',
18
'TRRD00001055543',
19
'TRRD00001055544',
20
'TRRD00001055545',
21
'TRRD00001055546',
22
'TRRD00001055547',
23
'TRRD00001055548',
24
'TRRD00001055549',
25
'TRRD00001055550',
26
'TRRD00001055551',
27
'TRRD00001055552',
28
'TRRD00001055553',
29
'TRRD00001055554',
30
'TRRD00001055555',
31
'TRRD00001055556',
32
'TRRD00001055557',
33
'TRRD00001055558',
34
'TRRD00001055559',
35
'TRRD00001055560',
36
'TRRD00001055561',
37
'TRRD00001055562',
38
'TRRD00001055563',
39
'TRRD00001055564',
40
'TRRD00001055565',
41
'TRRD00001055566',
42
'TRRD00001055567',
43
'TRRD00001055568',
44
'TRRD00001055569',
45
'TRRD00001055570',
46
'TRRD00001055571',
47
'TRRD00001055572',
48
'TRRD00001055573',
49
'TRRD00001055574',
50
'TRRD00001055575',
51
'TRRD00001055576',
52
'TRRD00001055577',
53
'TRRD00001055578',
54
'TRRD00001055579',
55
'TRRD00001055580',
56
'TRRD00001055581',
57
'TRRD00001055582',
58
'TRRD00001055583',
59
'TRRD00001055584',
60
'TRRD00001055585')
61
)