USP_MKTSEGMENTATIONEXPORTPROCESSOUTPUT_GETSTATUS

Retrieves the status of a marketing effort export process.

Parameters

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

Definition

Copy



create procedure dbo.[USP_MKTSEGMENTATIONEXPORTPROCESSOUTPUT_GETSTATUS]
(
  @BUSINESSPROCESSOUTPUTID uniqueidentifier,
  @STATUS xml output
)
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 = 
    'select' + char(13) +
    '  @STATUS = [STATUS]' + char(13) +
    'from dbo.[' + @TABLENAME + ']' + char(13) +
    'where [TABLEKEY] = @TABLEKEY';

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

  return 0;