UFN_MKTSOURCECODEPART_SEGMENTATIONSEGMENT_GETITEMLIST

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