USP_MKTSEGMENTATIONEXPORTPROCESS_CREATETABLE

CREATE procedure dbo.[USP_MKTSEGMENTATIONEXPORTPROCESS_CREATETABLE]
(
  @TABLENAME nvarchar(128),
  @COLUMNS nvarchar(max)
)
with execute as owner
as
  set nocount on;

  declare @SQL nvarchar(max);

  if left(@TABLENAME, 1) <> '#'
    begin
      --This is for creating real tables that we use in the export substitution views...

      set @SQL = 'create table dbo.[' + @TABLENAME + '] (' + char(13) +
                 @COLUMNS + char(13) +
                 ') on [OUTPUTGROUP];' + char(13);
      exec (@SQL);

      set @SQL = 'grant select, insert, update, alter, delete on dbo.[' + @TABLENAME + '] to [BBAPPFXSERVICEROLE]';
      exec (@SQL);
    end
  else
    begin
      --This is for creating temp tables...

      set @SQL = 'create table dbo.[' + @TABLENAME + '] (' + char(13) +
                 @COLUMNS + char(13) +
                 ');' + char(13);
      exec (@SQL);
    end

  return 0;