UFN_BUSINESSPROCESSSTATUS_CURRENTENQUEUEDGROUPJOBID

create function dbo.UFN_BUSINESSPROCESSSTATUS_CURRENTENQUEUEDGROUPJOBID
(
  @ENQUEUEGROUP nvarchar(255)
)
returns bigint
with execute as caller
as begin

  declare @ENQUEUEDJOBID bigint = 0;

  select
    @ENQUEUEDJOBID = isnull(max([ENQUEUEDJOBID]), 0)
  from 
    dbo.[BUSINESSPROCESSSTATUS] with (nolock) 
    inner join dbo.[BUSINESSPROCESSCATALOG] with (nolock) on [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID] = [BUSINESSPROCESSCATALOG].[ID]
  where 
    [BUSINESSPROCESSCATALOG].[ENQUEUEGROUP] = @ENQUEUEGROUP and 
    [STATUSCODE] in (1, 4);

  return @ENQUEUEDJOBID;
end