UFN_EXCHANGECONTACTSYNC_GETCONSTITUENTEMAILADDRESSES

            create function dbo.UFN_EXCHANGECONTACTSYNC_GETCONSTITUENTEMAILADDRESSES
            (
                @CONSTITUENTID uniqueidentifier
            )
            returns table
            as 
            return
            (
                SELECT 
                    dbo.UFN_EMAILADDRESSTYPECODE_GETDESCRIPTION(RANKEDEMAILADDRESSS.EMAILADDRESSTYPECODEID) as EMAILADDRESSTYPE, 
                    RANKEDEMAILADDRESSS.EMAILADDRESS,
                    EXCHANGEEMAILADDRESSMAPPING.OUTLOOKEMAILADDRESSTYPECODE,
                    RANKEDEMAILADDRESSS.ID
                from 
                    (select 
                        RANK() OVER (PARTITION BY EMAILADDRESSTYPECODEID order by DATEADDED) as SEQUENCE, 
                        EMAILADDRESSTYPECODEID, 
                        EMAILADDRESS,
                        ID
                    from 
                        dbo.EMAILADDRESS 
                    where 
                        CONSTITUENTID = @CONSTITUENTID
                    ) as RANKEDEMAILADDRESSS
                    inner join dbo.EXCHANGEEMAILADDRESSMAPPING on EXCHANGEEMAILADDRESSMAPPING.EMAILADDRESSTYPECODEID = RANKEDEMAILADDRESSS.EMAILADDRESSTYPECODEID
                where 
                    RANKEDEMAILADDRESSS.SEQUENCE = 1                    
            );