UP_PL_REQUEST_PROCESS_2.txt
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 |
) |