USP_REPORT_MATCHFINDERBATCHEXCEPTIONREPORT

Returns the data necessary for the MatchFinder Online Batch Exception report.

Parameters

Parameter Parameter Type Mode Description
@BATCHID uniqueidentifier IN

Definition

Copy


            create procedure dbo.USP_REPORT_MATCHFINDERBATCHEXCEPTIONREPORT
            (
                @BATCHID uniqueidentifier
            )
            as
            set nocount on;

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

            declare @SQLTOEXEC nvarchar(max);
            set @SQLTOEXEC = N'set nocount on;
                select ID, CONSTITUENTID, CONSTITUENTNAME, MATCHFINDERRECORDID, MFORGNAME, REASON from dbo.' + @TABLENAME;

            exec sp_executesql @SQLTOEXEC;