USP_REPORT_DIRECTMARKETINGEFFORTBATCHEXCEPTIONREPORT

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

  declare @SQL nvarchar(max);
  declare @TABLENAME nvarchar(128) = dbo.[UFN_BATCH_GETREPORTTABLENAME](@BATCHID, 1);

  set @SQL = 'select' + char(13) +
             '  [ID],' + char(13) +
             '  [MAILINGNAME],' + char(13) +
             '  [SOURCECODE],' + char(13) +
             '  [SEGMENTNAME],' + char(13) +
             '  [SEGMENTCODE],' + char(13) +
             '  [TESTSEGMENTNAME],' + char(13) +
             '  [TESTSEGMENTCODE],' + char(13) +
             '  [PACKAGENAME],' + char(13) +
             '  [PACKAGECODE],' + char(13) +
             '  [LISTNAME],' + char(13) +
             '  [LISTCODE],' + char(13) +
             '  [REASON]' + char(13) +
             'from dbo.[' + @TABLENAME + ']';
  exec sp_executesql @SQL;

  return 0;