USP_DATALIST_EVENTCAMPAIGN

Returns a list of campaigns associated with an event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



create procedure dbo.USP_DATALIST_EVENTCAMPAIGN(
@EVENTID uniqueidentifier
)
as
    set nocount on;

                    select
                            C.ID,
                            C.USERID,
                            C.NAME,
                            CAMPAIGNPRIORITYTYPECODE.DESCRIPTION + ' - ' + CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION as [SUBPRIORITY]
                        from 
                            dbo.EVENTCAMPAIGN EC
                        inner join 
                            dbo.CAMPAIGN C on EC.CAMPAIGNID = C.ID
                        left outer join 
                            dbo.CAMPAIGNSUBPRIORITY on CAMPAIGNSUBPRIORITY.ID = CAMPAIGNSUBPRIORITYID
                        left outer join
                            dbo.CAMPAIGNPRIORITY on CAMPAIGNSUBPRIORITY.CAMPAIGNPRIORITYID = CAMPAIGNPRIORITY.ID
                        left outer join
                            dbo.CAMPAIGNPRIORITYTYPECODE on CAMPAIGNPRIORITY.CAMPAIGNPRIORITYTYPECODEID = CAMPAIGNPRIORITYTYPECODE.ID
                        left join 
                            dbo.CAMPAIGNSUBPRIORITYNAMECODE on CAMPAIGNSUBPRIORITYNAMECODE.ID = CAMPAIGNSUBPRIORITY.CAMPAIGNSUBPRIORITYNAMECODEID
                        where 
                            EC.EVENTID = @EVENTID