USP_REPORT_CAMPAIGNPRIORITYPARAMETERS

Retrieve the information needed to build the parameter section of a Campaign Priority Report.

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNID	uniqueidentifier	IN
@CAMPAIGNPRIORITYTYPECODEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_REPORT_CAMPAIGNPRIORITYPARAMETERS
            (
                @CAMPAIGNID uniqueidentifier,
                @CAMPAIGNPRIORITYTYPECODEID uniqueidentifier = null
            )
            as
                select 
                    dbo.UFN_CAMPAIGN_GETNAME(@CAMPAIGNID) as NAME, 
                    case 
                        when dbo.UFN_CAMPAIGNPRIORITYTYPECODE_GETDESCRIPTION(@CAMPAIGNPRIORITYTYPECODEID) = '' then 
                            'All' 
                        else 
                            dbo.UFN_CAMPAIGNPRIORITYTYPECODE_GETDESCRIPTION(@CAMPAIGNPRIORITYTYPECODEID) 
                        end as CAMPAIGNPRIORITYTYPE