USP_DATALIST_DESIGNATIONCAMPAIGNFROMDESIGNATION

This datalist returns all designation campaigns for a designation.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONCAMPAIGNFROMDESIGNATION (
                    @DESIGNATIONID uniqueidentifier
                ) as
                    set nocount on;

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