UPDATE_PL_REQUEST_PROCESS_CUOGNVD.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 |
('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 |
) |