USP_REPORT_MODELINGANDPROPENSITYEXCEPTIONREPORT
Returns the data necessary for the Modeling and Propensity Batch Exception report.
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@BATCHID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_REPORT_MODELINGANDPROPENSITYEXCEPTIONREPORT(@BATCHID uniqueidentifier) with execute as owner
as
set nocount on;
declare @SQLTOEXEC nvarchar(200);
set @SQLTOEXEC = N'
set nocount on;
select
ID, IMPORTID, CONSTITUENTNAME, REASON
from
dbo.' + dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1);
exec sp_executesql @SQLTOEXEC;