USP_REPORT_PEOPLEFINDERBATCHEXCEPTION

CREATE procedure dbo.USP_REPORT_PEOPLEFINDERBATCHEXCEPTION
(
    @BATCHID uniqueidentifier
)
as
  begin
      set nocount on;

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

      declare @SQLTOEXEC nvarchar(400);
            set @SQLTOEXEC = N'set nocount on;
          select ID,
              NAME,
        NEWADDRESSBLOCK,
        NEWCITY,
        ABBREVIATION,
        NEWPOSTCODE,
        NEWPHONENUMBER,
        OTHERLASTNAME,
        ISDECEASED,
        DECEASEDYEAR
          from dbo.' + @TABLENAME;

      exec sp_executesql @SQLTOEXEC;
    end