USP_DATALIST_EDUCATIONALINSTITUTION

                CREATE procedure dbo.USP_DATALIST_EDUCATIONALINSTITUTION
                as
                    set nocount on;

                    select
                        ID,
                        FICECODE,
                        NAME,
                        CITY,
                        dbo.UFN_STATE_GETABBREVIATION(STATEID),
                        dbo.UFN_COUNTRY_GETDESCRIPTION(COUNTRYID),
                        ISAFFILIATED
                    from
                        dbo.EDUCATIONALINSTITUTION
                    order by
                        ISAFFILIATED desc, NAME;