UFN_MKTSEGMENTATION_HASACTIVESEGMENTS

create function dbo.UFN_MKTSEGMENTATION_HASACTIVESEGMENTS
(
    @MKTSEGMENTATIONID uniqueidentifier
)
returns bit
as begin
    declare @ret bit = 0;

    if exists (
            select top 1 1
            from dbo.MKTSEGMENTATIONSEGMENT
            inner join dbo.MKTSEGMENTATIONSEGMENTACTIVE
                on MKTSEGMENTATIONSEGMENT.ID = MKTSEGMENTATIONSEGMENTACTIVE.SEGMENTID
            where MKTSEGMENTATIONSEGMENT.SEGMENTATIONID = @MKTSEGMENTATIONID
        )
        set @ret = 1;

    return @ret;
end