USP_REPORT_APPEALPERFORMANCE_WITHIDSET

Added for backwards compatibility since USP_REPORT_APPEALPERFORMANCE no longer has the IDSetExtensiblity element that generates this stored procedure.

Parameters

Parameter	Parameter Type	Mode
@IDSETID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@CATEGORYID	uniqueidentifier	IN
@BUSINESSUNITID	uniqueidentifier	IN
@REPORTCODEID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN
@BYBREAKDOWN	bit	IN
@REPORTUSERID	nvarchar(128)	IN
@APPEALID	uniqueidentifier	IN
@CURRENCYCODE	tinyint	IN
@ALTREPORTUSERID	nvarchar(128)	IN

Definition

Copy



            CREATE procedure dbo.USP_REPORT_APPEALPERFORMANCE_WITHIDSET
            (
                @IDSETID uniqueidentifier = null,
                @STARTDATE datetime,
                @ENDDATE datetime,
                @CATEGORYID uniqueidentifier,
                @BUSINESSUNITID uniqueidentifier,
                @REPORTCODEID uniqueidentifier,
                @SITEID uniqueidentifier,
                @BYBREAKDOWN bit,
                @REPORTUSERID nvarchar(128),
                @APPEALID uniqueidentifier,
                @CURRENCYCODE tinyint,
                @ALTREPORTUSERID nvarchar(128)
            )
            with execute as owner  
            as  
                set nocount on;  

                declare @r int;  
                exec @r = dbo.[USP_REPORT_APPEALPERFORMANCE] @STARTDATE, @ENDDATE, @CATEGORYID, @BUSINESSUNITID, @REPORTCODEID, @SITEID, @BYBREAKDOWN, @REPORTUSERID, @APPEALID, @CURRENCYCODE, @ALTREPORTUSERID, @IDSETID;

                return @r;