USP_SIMPLEDATALIST_CONSTITUENTEDUCATIONALINSTITUTION

                CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTEDUCATIONALINSTITUTION
                (
                    @CONSTITUENTID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select distinct
                        INSTITUTION.ID as VALUE,
                        INSTITUTION.NAME as LABEL
                    from
                        dbo.EDUCATIONALINSTITUTION as INSTITUTION
                    inner join dbo.EDUCATIONALHISTORY as HISTORY on INSTITUTION.ID = HISTORY.EDUCATIONALINSTITUTIONID
                    where
                        HISTORY.CONSTITUENTID = @CONSTITUENTID;