UFN_BUSINESSPROCESSSTATUS_GETNAME

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_BUSINESSPROCESSSTATUS_GETNAME](@ID uniqueidentifier)
returns nvarchar(1024)
with execute as caller
as
begin
  declare @NAME nvarchar(1024)

  select
    @NAME = [V_BUSINESSPROCESSPARAMETERSETS].[NAME] + ': ' +
            [BUSINESSPROCESSSTATUS].[STATUS] + ' ' +
            convert(nvarchar, [BUSINESSPROCESSSTATUS].[STARTEDON], 120)
  from dbo.[BUSINESSPROCESSSTATUS]
  inner join dbo.[BUSINESSPROCESSCATALOG] on [BUSINESSPROCESSCATALOG].[ID] = [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID]
  inner join dbo.[V_BUSINESSPROCESSPARAMETERSETS] on [V_BUSINESSPROCESSPARAMETERSETS].[PARAMETERSETID] = [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSPARAMETERSETID]
  where [BUSINESSPROCESSSTATUS].[ID] = @ID;

  return @NAME
end