USP_REPORT_EVENTBATCHCONTROLREPORT

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

    declare @TABLENAME nvarchar(128);

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

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

    exec sp_executesql @SQLTOEXEC;