UFN_BATCHEVENTSPONSORSHIP_GETEMAILLIST

Get sponsor email lists

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHEVENTSPONSORSHIPID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHEVENTSPONSORSHIP_GETEMAILLIST(@BATCHEVENTSPONSORSHIPID uniqueidentifier)
returns table
as
return
(
    select
        ID,
        EMAILLISTGUID,
    SEQUENCE
    from
        dbo.BatchEventSponsorshipENewsletter
    where
        BATCHEVENTSPONSORSHIPID = @BATCHEVENTSPONSORSHIPID 
);