UFN_MKTSOURCECODEPART_GETITEMLIST

CREATE function dbo.[UFN_MKTSOURCECODEPART_GETITEMLIST]
(
  @SEGMENTATIONID 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]
    from dbo.[MKTSOURCECODEPART] as [PART]
    where 
      [PART].[SEGMENTATIONID] = @SEGMENTATIONID
      and [PART].[SEGMENTATIONSEGMENTID] is null
      and [PART].[SEGMENTATIONTESTSEGMENTID] is null
  )