USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENT_ALLSCHOOLS

CREATE procedure dbo.USP_SIMPLEDATALIST_ACADEMICCATALOGDEPARTMENT_ALLSCHOOLS( @INCLUDEALLNONE bit = 0 ) as

    select
        VALUE,
        LABEL
    from (
        select 
            '00000000-0000-0000-0000-000000000000' as VALUE, 
            'All Departments' as LABEL,
            0 as SEQUENCE
        where @INCLUDEALLNONE = 1

        union

        select 
            '00000000-0000-0000-0000-000000000001' as VALUE, 
            'No Departments' as LABEL,
            1 as SEQUENCE
        where @INCLUDEALLNONE = 1

        union

        select  
            d1.ID as VALUE,
            dbo.UFN_ACADEMICCATALOGDEPARTMENT_GETUSERIDFORDUPESCHOOL(d1.ID) as LABEL,
            3 as SEQUENCE
        from 
            dbo.ACADEMICCATALOGDEPARTMENT d1
        join 
            dbo.CONSTITUENT on CONSTITUENT.ID = d1.SCHOOLID
        join 
            dbo.ACADEMICCATALOGDEPARTMENT d2 on d1.USERID = d2.USERID
        group by 
            d1.ID, 
            d1.USERID, 
            CONSTITUENT.KEYNAME
    ) as t1
    order by 
        SEQUENCE,
        LABEL