USP_SMARTFIELD_AGGREGATERECOGNITIONAMOUNTS

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@TYPECODES	xml	IN
@DESIGNATIONS	xml	IN
@CALCULATIONTYPE	tinyint	IN
@ASOF	datetime	IN
@CAMPAIGNS	xml	IN
@CURRENCYID	uniqueidentifier	IN
@SMARTFIELDID	uniqueidentifier	IN
@SITES	xml	IN

Definition

Copy



            CREATE procedure dbo.USP_SMARTFIELD_AGGREGATERECOGNITIONAMOUNTS
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @TYPECODES xml,
                @DESIGNATIONS xml,                
                @CALCULATIONTYPE tinyint = 0,
                @ASOF datetime,
                @CAMPAIGNS xml = null,
                @CURRENCYID uniqueidentifier = null,
                @SMARTFIELDID uniqueidentifier = null,
                @SITES xml = null
            )
            as
                set nocount on;

                if not exists (select T.c.value('(SITEID)[1]','uniqueidentifier') from @SITES.nodes('/SITES/ITEM') T(c))
                    set @SITES = null;

                exec dbo.USP_CONSTITUENTSMARTFIELD_AGGREGATERECOGNITIONAMOUNTS @STARTDATE, @ENDDATE, @TYPECODES, @DESIGNATIONS, @CALCULATIONTYPE, @ASOF, @CAMPAIGNS, @CURRENCYID,
                    @SMARTFIELDID = @SMARTFIELDID, @SITES = @SITES;