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;