Operation Details |
Description: | Method to check for overlapping records. |
Sterotype: | nsmulti |
SQL |
SELECT educationID, courseType, statusCode, fromDate, toDate INTO :educationID, :courseType, :statusCode, :fromDate, :toDate FROM Education WHERE educationID <> :educationID AND concernRoleID = :concernRoleID AND statusCode = :statusCode AND courseType = :courseType AND ( ( :toDate >= fromDate OR :toDate IS NULL ) AND ( :fromDate <= toDate OR toDate IS NULL ) ) |