USP_SMARTFIELD_CONSTITUENTLASTAPPEALNAME

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@BUSINESSUNITS	xml	IN
@CATEGORIES	xml	IN
@REPORTCODES	xml	IN
@SITES	xml	IN
@ASOF	datetime	IN
@SMARTFIELDID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_SMARTFIELD_CONSTITUENTLASTAPPEALNAME
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @BUSINESSUNITS xml,
                @CATEGORIES xml,
                @REPORTCODES xml,
                @SITES xml,
                @ASOF datetime,
                @SMARTFIELDID uniqueidentifier = null
            )
            as
                set nocount on;                    
                exec dbo.USP_CONSTITUENTSMARTFIELD_APPEALVALUES @STARTDATE, @ENDDATE, @BUSINESSUNITS, @CATEGORIES, @REPORTCODES, @SITES, 2, @ASOF,
                    @SMARTFIELDID = @SMARTFIELDID;