USP_SMARTFIELD_LARGESTREVENUEDATE

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@TYPECODES	xml	IN
@DESIGNATIONS	xml	IN
@INCLUDESOFTCREDITS	bit	IN
@ASOF	datetime	IN
@CAMPAIGNS	xml	IN
@CURRENCYID	uniqueidentifier	IN
@SMARTFIELDID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_SMARTFIELD_LARGESTREVENUEDATE]
(
  @STARTDATE datetime = null,
  @ENDDATE datetime = null,
  @TYPECODES xml,
  @DESIGNATIONS xml,                
  @INCLUDESOFTCREDITS bit = 0,
  @ASOF datetime,
  @CAMPAIGNS xml = null,
  @CURRENCYID uniqueidentifier = null,
  @SMARTFIELDID uniqueidentifier = null
)
as
  set nocount on;

  exec dbo.[USP_CONSTITUENTSMARTFIELD_AGGREGATEREVENUEAMOUNTS] 
    @STARTDATE, 
    @ENDDATE, 
    @TYPECODES, 
    @DESIGNATIONS, 
    @INCLUDESOFTCREDITS, 
    6, 
    @ASOF, 
    @CAMPAIGNS,
    null,
    null,
    null,
    @CURRENCYID,
    @SMARTFIELDID = @SMARTFIELDID;