UFN_EXCHANGECONTACTSYNC_GETCONSTITUENTPHONES

            create function dbo.UFN_EXCHANGECONTACTSYNC_GETCONSTITUENTPHONES
            (
                @CONSTITUENTID uniqueidentifier
            )
            returns table
            as 
            return
            (
                SELECT 
                    dbo.UFN_PHONETYPECODE_GETDESCRIPTION(RANKEDPHONES.PHONETYPECODEID) AS PHONETYPE, 
                    RANKEDPHONES.NUMBER,
                    EXCHANGEPHONEMAPPING.OUTLOOKPHONETYPECODE,
                    RANKEDPHONES.ID
                from 
                    (select 
                        RANK() OVER (PARTITION BY PHONETYPECODEID order by DATEADDED) as SEQUENCE, 
                        PHONETYPECODEID, 
                        NUMBER,
                        PHONE.ID
                    from 
                        dbo.PHONE 
                    where 
                        CONSTITUENTID = @CONSTITUENTID
                    ) as RANKEDPHONES
                    inner join dbo.EXCHANGEPHONEMAPPING on EXCHANGEPHONEMAPPING.PHONETYPECODEID = RANKEDPHONES.PHONETYPECODEID
                where 
                    RANKEDPHONES.SEQUENCE = 1                    
            );