USP_REPORT_MODELINGANDPROPENSITYUPDATEBATCHEXCEPTIONREPORT

Returns the data necessary for the Modeling and Propensity Update Batch Exception Report.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



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

    declare @TABLENAME nvarchar(128);
    select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1)

    declare @SQLTOEXEC nvarchar(512);

    set @SQLTOEXEC = N'set nocount on;
        select 
            ID, CONSTITUENTNAME, LOOKUPID, ANNUALGIFTLIKELIHOOD, MAJORGIVINGLIKELIHOOD, RANGE, REASON
        from dbo.' + @TABLENAME;
    exec sp_executesql @SQLTOEXEC;