USP_DATALIST_DESIGNATIONCAMPAIGNFROMCAMPAIGN

This datalist returns all designation campaigns for a campaign.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONCAMPAIGNFROMCAMPAIGN (
                    @CAMPAIGNID uniqueidentifier
                ) as
                    set nocount on;

                    select
                        DESIGNATIONCAMPAIGN.ID,
                        DESIGNATION.ID as DESIGNATIONID,
                        DESIGNATION.NAME as DESIGNATIONNAME,
                        CAMPAIGNPRIORITYTYPECODE.DESCRIPTION + ' - ' + CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION as [SUBPRIORITYNAME],
                        DESIGNATIONCAMPAIGN.DATEFROM,
                        DESIGNATIONCAMPAIGN.DATETO
                    from 
                        dbo.DESIGNATIONCAMPAIGN
                    inner join 
                        dbo.DESIGNATION on DESIGNATIONCAMPAIGN.DESIGNATIONID = DESIGNATION.ID
                    left outer join 
                        dbo.CAMPAIGNSUBPRIORITY on DESIGNATIONCAMPAIGN.CAMPAIGNSUBPRIORITYID = CAMPAIGNSUBPRIORITY.ID
                    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 
                        DESIGNATIONCAMPAIGN.CAMPAIGNID = @CAMPAIGNID