USP_KPI_CAMPAIGNPRIORITY_GOALVALUE

Parameters

Parameter	Parameter Type	Mode
@VALUE	money	INOUT
@CAMPAIGNID	uniqueidentifier	IN
@PRIORITYID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



          CREATE procedure dbo.USP_KPI_CAMPAIGNPRIORITY_GOALVALUE(
            @VALUE money output,
            @CAMPAIGNID uniqueidentifier,
            @PRIORITYID uniqueidentifier,
            @STARTDATE datetime = null,
            @ENDDATE datetime = null,
            @CURRENCYID uniqueidentifier = null
        ) as 
          begin
            set nocount on;       
              set @VALUE = 0;

            select
                  @VALUE = GOAL
              from
                  dbo.CAMPAIGNPRIORITY
              where
                  ID = @PRIORITYID
              and
                  CAMPAIGNID = @CAMPAIGNID
          end