USP_REPORT_EVENTREGISTRANTBATCHEXCEPTIONREPORT

create procedure dbo.USP_REPORT_EVENTREGISTRANTBATCHEXCEPTIONREPORT
(
    @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(250);
    set @SQLTOEXEC = N'
        set nocount on;
        select
            ID,
            EVENTNAME,
            CONSTITUENTNAME,
            EVENTPRICE,
            REASON
        from
            dbo.' + @TABLENAME;

    exec sp_executesql @SQLTOEXEC;