USP_MKTSEGMENTATIONEXPORTPROCESS_CREATETEMPVIEW
Creates a temporary view used when exporting data for a marketing effort.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @VIEWNAME | nvarchar(256) | IN | |
| @SELECTSQL | nvarchar(max) | IN |
Definition
Copy
create procedure dbo.[USP_MKTSEGMENTATIONEXPORTPROCESS_CREATETEMPVIEW]
(
@VIEWNAME nvarchar(256),
@SELECTSQL nvarchar(max)
)
with execute as owner
as
declare @SQL nvarchar(max);
set nocount on;
set @SQL =
'create view dbo.[' + @VIEWNAME + '] as' + char(13) +
@SELECTSQL + ';';
exec (@SQL);
set @SQL = 'grant select on dbo.[' + @VIEWNAME + '] to BBAPPFXSERVICEROLE';
exec (@SQL);
return 0;