USP_MKTSEGMENTATIONEXPORTPROCESS_CREATESATORITABLE

Creates a temporary table used when exporting data for a marketing effort.

Parameters

Parameter	Parameter Type	Mode	Description
@SATORITABLENAME	nvarchar(128)	IN
@COLUMNSSQL	nvarchar(max)	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTSEGMENTATIONEXPORTPROCESS_CREATESATORITABLE]
(
  @SATORITABLENAME nvarchar(128),
  @COLUMNSSQL nvarchar(max)
)
with execute as owner
as
  set nocount on;

  declare @SQL nvarchar(max);

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

  set @SQL = 'grant select, insert, update, alter, delete on dbo.[' + @SATORITABLENAME + '] to [BBAPPFXSERVICEROLE]';
  exec (@SQL);

  return 0;