UFN_TICKETEMAIL_GETRECIPIENTEMAILADDRESS

create function dbo.UFN_TICKETEMAIL_GETRECIPIENTEMAILADDRESS(
    @SALESORDERID uniqueidentifier
)
returns dbo.UDT_EMAILADDRESS
with execute as caller
as begin

    declare @EMAILADDRESS dbo.UDT_EMAILADDRESS
    select @EMAILADDRESS = EMAILADDRESS.EMAILADDRESS
    from dbo.UFN_SALESORDER_CONTACTRECORDS(@SALESORDERID) CONTACTRECORDS
        inner join dbo.EMAILADDRESS on EMAILADDRESS.ID = CONTACTRECORDS.EMAILADDRESSID

    if @EMAILADDRESS is null
    begin
        select @EMAILADDRESS = EMAILADDRESS.EMAILADDRESS
        from dbo.SALESORDER
            inner join dbo.EMAILADDRESS on EMAILADDRESS.CONSTITUENTID = SALESORDER.CONSTITUENTID
        where EMAILADDRESS.ISPRIMARY = 1
            and SALESORDER.ID = @SALESORDERID
    end

    return @EMAILADDRESS
end