USP_DATALIST_EDUCATIONALINSTITUTION2

                CREATE procedure dbo.USP_DATALIST_EDUCATIONALINSTITUTION2
                as
                    set nocount on;

                    select
                        E.ID,
                        E.FICECODE,
                        E.NAME,
                        E.CITY,
                        dbo.UFN_STATE_GETABBREVIATION(E.STATEID),
                        dbo.UFN_COUNTRY_GETDESCRIPTION(E.COUNTRYID),
                        ADDRESS.ADDRESSBLOCK, 
                        ADDRESS.POSTCODE,
                        PHONE.NUMBER
                    from
                        dbo.EDUCATIONALINSTITUTION as E
                        left outer join dbo.ADDRESS on E.ID = ADDRESS.CONSTITUENTID and ADDRESS.ISPRIMARY = 1
                        left outer join dbo.PHONE on E.ID = PHONE.CONSTITUENTID and PHONE.ISPRIMARY = 1
                    where E.ISAFFILIATED = 0
                    order by
                        E.NAME;