Project

General

Profile

UP_PL_REQUEST_PROCESS_2.txt

Truong Nguyen Vu, 09/01/2020 03:54 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
('TRRDI001055532',
8
'TRRDI001055533',
9
'TRRDI001055534',
10
'TRRDI001055535',
11
'TRRDI001055536',
12
'TRRDI001055537',
13
'TRRDI001055538',
14
'TRRDI001055539',
15
'TRRDI001055540',
16
'TRRDI001055541',
17
'TRRDI001055542',
18
'TRRDI001055543',
19
'TRRDI001055544',
20
'TRRDI001055545',
21
'TRRDI001055546',
22
'TRRDI001055547',
23
'TRRDI001055548',
24
'TRRDI001055549',
25
'TRRDI001055550',
26
'TRRDI001055551',
27
'TRRDI001055552',
28
'TRRDI001055553',
29
'TRRDI001055554',
30
'TRRDI001055555',
31
'TRRDI001055556',
32
'TRRDI001055557',
33
'TRRDI001055558',
34
'TRRDI001055559',
35
'TRRDI001055560',
36
'TRRDI001055561',
37
'TRRDI001055562',
38
'TRRDI001055563',
39
'TRRDI001055564',
40
'TRRDI001055565',
41
'TRRDI001055566',
42
'TRRDI001055567',
43
'TRRDI001055568',
44
'TRRDI001055569',
45
'TRRDI001055570',
46
'TRRDI001055571',
47
'TRRDI001055572',
48
'TRRDI001055573',
49
'TRRDI001055574',
50
'TRRDI001055575',
51
'TRRDI001055576',
52
'TRRDI001055577',
53
'TRRDI001055578',
54
'TRRDI001055579',
55
'TRRDI001055580',
56
'TRRDI001055581',
57
'TRRDI001055582',
58
'TRRDI001055583',
59
'TRRDI001055584',
60
'TRRDI001055585')
61
)