UFN_MKTSEGMENTATION_ISCALCULATING

CREATE function dbo.[UFN_MKTSEGMENTATION_ISCALCULATING]
(
  @SEGMENTATIONID uniqueidentifier
)
returns bit
as
begin
  return
  (
    select (case when [MKTSEGMENTATION].[ACTIVE] = 0 and exists (
               select 1
               from dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS]
               inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[ID]
               where [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID] = '585d30cc-c822-4441-a161-f8a2306bda8d'
               and [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[PARAMETERSETID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ID]
               and [BUSINESSPROCESSSTATUS].[STATUSCODE] = 1)
            then 1 else 0 end)
    from dbo.[MKTSEGMENTATION]
    inner join dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] on [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
    where [MKTSEGMENTATION].[ID] = @SEGMENTATIONID
  );
end