DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID= (SELECT TOP 1 T.PROCESS_ID FROM dbo.PL_REQUEST_PROCESS T  WHERE T.REQ_ID=PL_REQUEST_PROCESS.REQ_ID AND T.PROCESS_ID <>'APPROVE' ORDER BY T.ID DESC) WHERE  

 PROCESS_ID='APPROVE' AND PARENT_PROCESS_ID='PTGD_DC'

 UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='C' WHERE PROCESS_ID='APPROVE' AND REQ_ID IN (SELECT REQ_ID FROM dbo.PL_REQUEST_PROCESS WHERE STATUS <>'C')