UFN_SELECTION_MKTSEGMENT_ALLSEGMENTS

    CREATE function dbo.[UFN_SELECTION_MKTSEGMENT_ALLSEGMENTS]()
    returns table
    as
        return 
        (
            select 
                [MKTSEGMENT].[ID] 
            from 
                dbo.[MKTSEGMENT]
            where
                /* Exclude appeal mailing segments */
                not exists(select 1
                    from dbo.[APPEALMAILING]
                    inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [APPEALMAILING].[MKTSEGMENTATIONSEGMENTID]
                    where [MKTSEGMENTATIONSEGMENT].[SEGMENTID] = [MKTSEGMENT].[ID])
        );