USP_BBNC_GETEDUCATIONALINSTITUTIONS

            CREATE procedure dbo.USP_BBNC_GETEDUCATIONALINSTITUTIONS

            as

                set nocount on;            

                select 
                    EDUCATIONALINSTITUTION.ID, BBNCCODETABLEIDMAP.ID as BBNCID, EDUCATIONALINSTITUTION.NAME as DESCRIPTION
                from 
                    dbo.EDUCATIONALINSTITUTION 
                inner join dbo.BBNCCODETABLEIDMAP 
                    on EDUCATIONALINSTITUTION.ID = BBNCCODETABLEIDMAP.TABLEENTRYID
                    and BBNCCODETABLEIDMAP.CODETABLECATALOGID = '0E885882-A716-49B8-8F2F-A6BAE5D220D8'
                order by
                    ISAFFILIATED desc, DESCRIPTION