UFN_BBNC_GETMATCHINGEDUCATIONALINSTITUTIONID

create function dbo.UFN_BBNC_GETMATCHINGEDUCATIONALINSTITUTIONID
            (
                @MAPID integer,
                @SCHOOLNAME nvarchar(100)
            )
            returns uniqueidentifier
            as
            begin
                return
                (
                    select top (1)
                        EI.[ID]
                    from
                        dbo.EDUCATIONALHISTORY EH
            left join dbo.CONSTITUENT C on EH.CONSTITUENTID = C.ID
                        left join dbo.EDUCATIONALINSTITUTION EI on EH.EDUCATIONALINSTITUTIONID = EI.ID
                    where
                        C.SEQUENCEID = @MAPID
                        and upper(EI.NAME) = upper(@SCHOOLNAME)
                    order by
                        EI.[DATECHANGED] desc
                )
            end