USP_REPORT_DIRECTMARKETINGEFFORTBATCHCONTROLREPORT

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

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

  set @SQL = 'select' + char(13) +
             '  [CONTROL].[ID],' + char(13) +
             '  [CONTROL].[MAILINGNAME],' + char(13) +
             '  [CONTROL].[SOURCECODE],' + char(13) +
             '  [CONTROL].[SEGMENTNAME],' + char(13) +
             '  [CONTROL].[SEGMENTCODE],' + char(13) +
             '  [CONTROL].[TESTSEGMENTNAME],' + char(13) +
             '  [CONTROL].[TESTSEGMENTCODE],' + char(13) +
             '  [CONTROL].[PACKAGENAME],' + char(13) +
             '  [CONTROL].[PACKAGECODE],' + char(13) +
             '  [CONTROL].[LISTNAME],' + char(13) +
             '  [CONTROL].[LISTCODE]' + char(13) +
             'from dbo.[' + @TABLENAME + '] as [CONTROL]' + char(13) +
             'left join dbo.[BATCHDIRECTMARKETINGEFFORT] on [BATCHDIRECTMARKETINGEFFORT].[ID] = [CONTROL].[BATCHRECORDID]' + char(13) +
             'order by [BATCHDIRECTMARKETINGEFFORT].[SEQUENCE]';

  exec sp_executesql @SQL;

  return 0;