USP_MKTSEGMENTATIONEXPORTPROCESSOUTPUT_UPDATESTATUS

Updates the status of a marketing effort export process.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSOUTPUTID	uniqueidentifier	IN
@STATUS	xml	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTSEGMENTATIONEXPORTPROCESSOUTPUT_UPDATESTATUS]
(
  @BUSINESSPROCESSOUTPUTID uniqueidentifier,
  @STATUS xml
)
as
  set nocount on;

  declare @BUSINESSPROCESSSTATUSID uniqueidentifier;
  declare @TABLEKEY nvarchar(50);
  declare @TABLENAME nvarchar(255);
  declare @SQL nvarchar(max);

  select 
    @BUSINESSPROCESSSTATUSID = [BUSINESSPROCESSSTATUSID],
    @TABLEKEY = [TABLEKEY]
  from 
    dbo.[BUSINESSPROCESSOUTPUT] 
  where 
    [ID] = @BUSINESSPROCESSOUTPUTID;

  select
    @TABLENAME = [TABLENAME]
  from
    dbo.[BUSINESSPROCESSOUTPUT]
  where
    upper([TABLEKEY]) = upper(convert(nvarchar(36), @BUSINESSPROCESSSTATUSID))

  set @SQL = 
    'update dbo.[' + @TABLENAME + ']' + char(13) +
    'set [STATUS] = @STATUS' + char(13) +
    'where [TABLEKEY] = @TABLEKEY';

  exec sp_executesql @SQL, N'@STATUS xml, @TABLEKEY nvarchar(50)', @STATUS = @STATUS, @TABLEKEY = @TABLEKEY;

  return 0;