UFN_BBNC_CONSTITUENT_EMAILADDRESS

create function dbo.UFN_BBNC_CONSTITUENT_EMAILADDRESS(@CONSTITUENTID uniqueidentifier)
returns nvarchar(100)
with execute as caller
as begin

    declare @EMAILPHONETYPE int
    select @EMAILPHONETYPE =  EmailPhoneType from dbo.clients

    declare @EMAILADDRESS nvarchar(100)

    set @EMAILADDRESS = (
                            select top 1 EA.EMAILADDRESS as NUMBER
                            from
                            dbo.CONSTITUENT C
                            inner join dbo.EMAILADDRESS EA on C.ID = EA.CONSTITUENTID
                            left join dbo.EMAILADDRESSTYPECODE EATC on EA.EMAILADDRESSTYPECODEID = EATC.ID
                            inner join dbo.BBNCCODETABLEIDMAP as BCTIM on BCTIM.TABLEENTRYID = EATC.ID
                            where C.ID = @CONSTITUENTID and BCTIM.ID = @EMAILPHONETYPE 
                            order by ISPRIMARY desc, EA.SEQUENCE
                        )

    return @EMAILADDRESS
end