USP_DATALIST_REVENUESPLITCAMPAIGN

Returns a list of campaigns associated with a revenue split.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_REVENUESPLITCAMPAIGN
                    (
                        @REVENUESPLITID uniqueidentifier
                    )
                    as
                        set nocount on

                        select
                            CAMPAIGN.ID,
                            CAMPAIGN.NAME,
                            CAMPAIGNPRIORITYTYPECODE.DESCRIPTION + ' - ' + CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION as [SUBPRIORITY]
                        from 
                            dbo.REVENUESPLITCAMPAIGN
                        inner join 
                            dbo.CAMPAIGN on REVENUESPLITCAMPAIGN.CAMPAIGNID = CAMPAIGN.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 
                            REVENUESPLITCAMPAIGN.REVENUESPLITID = @REVENUESPLITID
                        order by CAMPAIGN.NAME