UFN_BATCHCONSTITUENTUPDATE_GETEMAILADDRESSES_WITHDATES

Returns all emailaddresses for a given batch constituentupdate record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



    CREATE function dbo.UFN_BATCHCONSTITUENTUPDATE_GETEMAILADDRESSES_WITHDATES(
        @BATCHCONSTITUENTUPDATEID uniqueidentifier
    ) returns table
    as
    return
    (
        select
            ID,
            UPDATEHOUSEHOLD,
            EMAILADDRESSTYPECODEID,
            EMAILADDRESS,
            ISPRIMARY,
            DONOTEMAIL,
            SEQUENCE,
            STARTDATE,
            INFOSOURCECODEID,
            EMAILADDRESSID
        from
            dbo.BATCHCONSTITUENTUPDATEEMAILADDRESSES
        where
            BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
    );