USP_REPORT_EVENTBATCHEXCEPTIONREPORT

create procedure dbo.USP_REPORT_EVENTBATCHEXCEPTIONREPORT
(
    @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(200);
    set @SQLTOEXEC = N'
        set nocount on;
        select
            ID, NAME, STARTDATE, REASON
        from
            dbo.' + @TABLENAME;

    exec sp_executesql @SQLTOEXEC;