UFN_EVENT_CAMPAIGNS

This function returns all of the campaigns associated with an event.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENT_CAMPAIGNS (
                @EVENTID uniqueidentifier
            ) returns table
            as return
                select
                    EC.ID,
                    EC.CAMPAIGNID,
                    EC.CAMPAIGNSUBPRIORITYID
                from
                    dbo.EVENTCAMPAIGN EC
                where
                    EC.EVENTID = @EVENTID