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;