USP_REPORT_MATCHFINDERBATCHCONTROLREPORT

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

Parameters

Parameter Parameter Type Mode Description
@BATCHID uniqueidentifier IN

Definition

Copy


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

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

            declare @SQLTOEXEC nvarchar(max);
            set @SQLTOEXEC = N'set nocount on;
                select ID, NAME from dbo.' + @TABLENAME;

            exec sp_executesql @SQLTOEXEC;