UFN_DONATIONBATCH_GETEMAILLIST

Get donation email lists

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DONATIONBATCHID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_DONATIONBATCH_GETEMAILLIST(@DONATIONBATCHID uniqueidentifier)
returns table
as
return
(
    select
        ID,
        EMAILLISTGUID,
    SEQUENCE
    from
        dbo.DONATIONBATCHENEWSLETTER
    where
        DONATIONBATCHID = @DONATIONBATCHID
);