USP_DATALIST_MEMBERSHIPPROGRAMCAMPAIGN

Returns a list of campaigns associated with a membership program.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMCAMPAIGN(
@MEMBERSHIPPROGRAMID uniqueidentifier
)
as
    set nocount on;

                    select
                            C.ID,
                            C.USERID,
                            C.NAME,
                            CAMPAIGNPRIORITYTYPECODE.DESCRIPTION + ' - ' + CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION as [SUBPRIORITY],
                            MPC.DATEFROM,
                            MPC.DATETO
                        from 
                            dbo.MEMBERSHIPPROGRAMCAMPAIGN MPC
                        inner join 
                            dbo.CAMPAIGN C on MPC.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 
                            MPC.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID