FILE 1.txt
| 1 |
|
|---|---|
| 2 |
UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID=(SELECT TOP 1 PROCESS_ID FROM dbo.PL_REQUEST_PROCESS T WHERE REQ_ID IN ( SELECT REQ_ID FROM dbo.PL_REQUEST_PROCESS WHERE PARENT_PROCESS_ID='GDK_DC') AND PROCESS_ID <>'APPROVE' AND T.REQ_ID=dbo.PL_REQUEST_PROCESS.REQ_ID |
| 3 |
ORDER BY REQ_ID,ID DESC) WHERE PL_REQUEST_PROCESS.PROCESS_ID='APPROVE' |