Operation Details |
Description: | Select a distinct set of case id's for the same runID. |
Sterotype: | nsmulti |
SQL |
SELECT caseID INTO :recordID FROM PDMRunCaseControl WHERE runID = :runID AND status = :status AND statusDateTime <= :statusDateTime ORDER BY caseID ASC |