UFN_MKTSOURCECODEPART_SEGMENTATIONTESTSEGMENT_GETITEMLIST

CREATE function dbo.[UFN_MKTSOURCECODEPART_SEGMENTATIONTESTSEGMENT_GETITEMLIST]
(
  @SEGMENTATIONTESTSEGMENTID uniqueidentifier
)
/*
Returns a table of all of the source code items that have been assigned to the given segmentationtestsegment
*/
returns table
as
  return 
  (
    select 
      [PART].[ID], 
      [PART].[CODE], 
      [PART].[SOURCECODEITEMID], 
      [PART].[PARTDEFINITIONVALUESID],
      [PART].[SEGMENTATIONID]
    from dbo.[MKTSOURCECODEPART] as [PART]
    where [PART].[SEGMENTATIONTESTSEGMENTID] = @SEGMENTATIONTESTSEGMENTID
  )