UFN_MKTSEGMENTATIONACTIVATE_GETSEGMENTS

CREATE function dbo.[UFN_MKTSEGMENTATIONACTIVATE_GETSEGMENTS]
(
  @SEGMENTATIONID uniqueidentifier
)
returns table
as
  return
  (
    select top 100 percent
      [TEMP].[ID] as [SEGMENTID], 
      [TEMP].[TESTID] as [TESTSEGMENTID],
      [TEMP].[EXCLUDE]
    from (
      select [ID], [EXCLUDE], [SEQUENCE], null as [TESTID], null as [TESTSEQUENCE]
      from [MKTSEGMENTATIONSEGMENT]
      where [SEGMENTATIONID] = @SEGMENTATIONID
      union
      select [SEG].[ID], [SEG].[EXCLUDE], [SEG].[SEQUENCE], [TESTSEG].[ID] as [TESTID], [TESTSEG].[SEQUENCE] as [TESTSEQUENCE]
      from [MKTSEGMENTATIONSEGMENT] as [SEG]
      left join [MKTSEGMENTATIONTESTSEGMENT] as [TESTSEG] on [TESTSEG].[SEGMENTID] = [SEG].[ID]
      where [SEG].[SEGMENTATIONID] = @SEGMENTATIONID
    ) as [TEMP]
    group by [TEMP].[ID], [TEMP].[EXCLUDE], [TEMP].[TESTID], [TEMP].[SEQUENCE], [TEMP].[TESTSEQUENCE]
    order by [TEMP].[SEQUENCE], [TEMP].[TESTSEQUENCE]
  );