UFN_MKTSEGMENTGROUP_GETSEGMENTS2

create function dbo.[UFN_MKTSEGMENTGROUP_GETSEGMENTS2]
(
  @SEGMENTGROUPID uniqueidentifier
)
returns table
as
  return 
  (
    select 
      [MKTGROUPSEGMENTS].[ID],
      [MKTGROUPSEGMENTS].[SEGMENTID],
      [MKTSEGMENT].[NAME],
      [MKTSEGMENT].[CODE],
      [MKTSEGMENT].[DESCRIPTION],
      [MKTGROUPSEGMENTS].[SEQUENCE] as [SEQUENCE],
      [MKTSEGMENT].[SEGMENTTYPECODE],
      [MKTSEGMENT].[PARTDEFINITIONVALUESID] as [CODEVALUEID]
    from dbo.[MKTSEGMENT]
    inner join dbo.[MKTGROUPSEGMENTS] on [MKTSEGMENT].[ID] = [MKTGROUPSEGMENTS].[SEGMENTID]
    where [MKTGROUPSEGMENTS].[SEGMENTGROUPID] = @SEGMENTGROUPID
  )