UFN_MKTSOURCECODEPART_SEGMENTATIONSEGMENT_GETITEMLIST2

CREATE function dbo.[UFN_MKTSOURCECODEPART_SEGMENTATIONSEGMENT_GETITEMLIST2]
(
  @SEGMENTATIONSEGMENTID uniqueidentifier
)
returns table
as
  return 
  (
    select
      [MKTSOURCECODEPART].[ID],
      [MKTSOURCECODEPARTDEFINITION].[ITEMTYPECODE] as [SOURCECODEPARTTYPE],
      [MKTSOURCECODEITEM].[ID] as [SOURCECODEITEMID],
      [MKTSOURCECODEPARTDEFINITION].[ID] as [PARTDEFINITIONID],
      [MKTSOURCECODEPARTDEFINITION].[NAME] as [PARTDEFINITIONNAME],
      [MKTSOURCECODEPART].[PARTDEFINITIONVALUESID],
      [MKTSOURCECODEPART].[CODE],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[REGEX] as [CODEREGEX],
      [MKTSOURCECODEITEM].[SEQUENCE]
    from dbo.[MKTSOURCECODEPART]
    inner join dbo.[MKTSOURCECODEITEM] on [MKTSOURCECODEITEM].[ID] = [MKTSOURCECODEPART].[SOURCECODEITEMID]
    inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITION].[ID] = [MKTSOURCECODEITEM].[MKTSOURCECODEPARTDEFINITIONID]
    inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] = [MKTSOURCECODEPART].[PARTDEFINITIONVALUESID]
    where [MKTSOURCECODEPART].[SEGMENTATIONSEGMENTID] = @SEGMENTATIONSEGMENTID
  );