• Are you saying that you only need to SELECT the data WHERE cAbsenceCode = 'P' OR cAbsenceCode= 'S'? and ORDER the results BY dtEnrollmentDate?

    Thomas Rushton
    blog: https://thelonedba.wordpress.com