USP_SMARTFIELD_ANNUALRENEWER

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
@SMARTFIELDID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_SMARTFIELD_ANNUALRENEWER
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @TYPECODES xml,
                @DESIGNATIONS xml,                
                @INCLUDESOFTCREDITS bit = 0,
                @ASOF datetime,
                @CAMPAIGNS xml = null,
                @SMARTFIELDID uniqueidentifier = null
            )
            as
                set nocount on;                    
                exec dbo.USP_CONSTITUENTSMARTFIELD_AGGREGATEREVENUEAMOUNTS @STARTDATE, @ENDDATE, @TYPECODES, @DESIGNATIONS, @INCLUDESOFTCREDITS, 9, @ASOF, @CAMPAIGNS,
                    @SMARTFIELDID = @SMARTFIELDID;