UFN_MKTSEGMENTGROUP_GETSEGMENTS

CREATE function dbo.[UFN_MKTSEGMENTGROUP_GETSEGMENTS]
(
  @SEGMENTGROUPID uniqueidentifier
)
returns table
as
  return 
  (
    select 
      [MKTGROUPSEGMENTS].[ID],
      [MKTGROUPSEGMENTS].[SEGMENTID],
      [MKTSEGMENT].[NAME],
      [MKTSEGMENT].[CODE],
      [MKTSEGMENT].[DESCRIPTION],
      [MKTGROUPSEGMENTS].[SEQUENCE] as [SEQUENCE],
      [MKTSEGMENT].[SEGMENTTYPE],
      dbo.[UFN_MKTSEGMENT_ISINUSE]([MKTSEGMENT].[ID]) as [INUSE]
    from dbo.[MKTSEGMENT]
    inner join dbo.[MKTGROUPSEGMENTS] on [MKTSEGMENT].[ID] = [MKTGROUPSEGMENTS].[SEGMENTID]
    where [MKTGROUPSEGMENTS].[SEGMENTGROUPID] = @SEGMENTGROUPID
  )