USP_REPORT_PHONEFINDERBATCHEXCEPTION

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

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

    declare @SQLTOEXEC nvarchar(1000) =
        N'set nocount on;
            select
                ' + @TABLENAME + '.[ID],
                ' + @TABLENAME + '.[NAME],
                ' + @TABLENAME + '.[PHONENUMBER],
                ' + @TABLENAME + '.[REASON]
            from
                dbo.' + @TABLENAME + ';';


    exec sp_executesql @SQLTOEXEC;

    return 0;