USP_SIMPLEDATALIST_SCHOOL

        CREATE procedure dbo.USP_SIMPLEDATALIST_SCHOOL as
            select 
                SCHOOL.ID as VALUE, 
                KEYNAME as LABEL
            from 
                dbo.SCHOOL
            join
                dbo.CONSTITUENT on CONSTITUENT.ID = SCHOOL.ID
            order by KEYNAME