UFN_MKTSEGMENTATIONACTIVATE_HASINACTIVETESTMAILING

CREATE function dbo.UFN_MKTSEGMENTATIONACTIVATE_HASINACTIVETESTMAILING
(
  @SEGMENTATIONID uniqueidentifier
)
returns bit
as begin
    return (select 
              case 
                when exists(
                  select 1
                  from dbo.[MKTSEGMENTATION] [PARENT]
                  inner join dbo.[MKTSEGMENTATION] [CHILD]
                  on [PARENT].[ID] = [CHILD].[PARENTSEGMENTATIONID]
                  where [CHILD].[ACTIVE] = 0
                  and [PARENT].[ID] = @SEGMENTATIONID)
                then 1
                else 0
              end);
end