USP_REPORT_CAMPAIGNSUMMARYPARAMETERS

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

Parameters

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

Definition

Copy



            create procedure dbo.USP_REPORT_CAMPAIGNSUMMARYPARAMETERS
            (
                @CAMPAIGNID uniqueidentifier = null,
                @CAMPAIGNHIERARCHYGOALID uniqueidentifier = null
            )
            as
                select 
                    dbo.UFN_CAMPAIGN_GETNAME(@CAMPAIGNID) as NAME, 
                    NAME as GOALNAME,
                    STARTDATE as GOALSTARTDATE,
                    ENDDATE as GOALENDDATE
                from CAMPAIGNHIERARCHYGOAL
                where ID=@CAMPAIGNHIERARCHYGOALID;