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;