UFN_MKTCONSTITUENTFILEIMPORT_CURRENTLYRUNBY

Return

Return Type
nvarchar(128)

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN
@IGNORESTATUSID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_MKTCONSTITUENTFILEIMPORT_CURRENTLYRUNBY]
(
  @SEGMENTATIONID uniqueidentifier,
  @IGNORESTATUSID uniqueidentifier
)
returns nvarchar(128)
as
begin
  return (
    select top 1
      [APPUSER].[USERNAME]
    from dbo.[MKTCONSTITUENTFILEIMPORTPROCESS]
    inner join dbo.[MKTCONSTITUENTFILEIMPORTPROCESSSTATUS] on [MKTCONSTITUENTFILEIMPORTPROCESSSTATUS].[PARAMETERSETID] = [MKTCONSTITUENTFILEIMPORTPROCESS].[ID]
    inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTCONSTITUENTFILEIMPORTPROCESSSTATUS].[ID]
    inner join dbo.[APPUSER] on [APPUSER].[ID] = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID]
    where [MKTCONSTITUENTFILEIMPORTPROCESS].[SEGMENTATIONID] = @SEGMENTATIONID
    and [BUSINESSPROCESSSTATUS].[STATUSCODE] = 1
    and [BUSINESSPROCESSSTATUS].[ID] <> @IGNORESTATUSID
  );
end