UFN_REGISTRANTBATCH_GETEMAILLIST

Get registrant email lists

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REGISTRANTBATCHID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_REGISTRANTBATCH_GETEMAILLIST(@REGISTRANTBATCHID uniqueidentifier)
returns table
as
return
(
    select
        ID,
        EMAILLISTGUID
    from
        dbo.REGISTRANTBATCHENEWSLETTER
    where
        REGISTRANTBATCHID = @REGISTRANTBATCHID
);