USP_REPORT_RE7INTEGRATIONGIVINGSUMMARYEXCEPTIONREPORT

Returns the data necessary for the RE7 Integration Giving Summary Batch Exception report.

Parameters

Parameter Parameter Type Mode Description
@BATCHID uniqueidentifier IN

Definition

Copy


            CREATE procedure dbo.USP_REPORT_RE7INTEGRATIONGIVINGSUMMARYEXCEPTIONREPORT(@BATCHID uniqueidentifier) with execute as owner
            as
                set nocount on;

                declare @SQLTOEXEC nvarchar(200);
                set @SQLTOEXEC = N'
                    set nocount on;
                    select 
                        ID, CONSTITUENTID, CONSTITUENTNAME, REASON
                    from
                        dbo.' + dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1);
                exec sp_executesql @SQLTOEXEC;