UFN_MKTCOMMUNICATIONEFFORT_GETNAMESCHEMEPARTS

CREATE function dbo.[UFN_MKTCOMMUNICATIONEFFORT_GETNAMESCHEMEPARTS]
(
  @SEGMENTATIONID uniqueidentifier
)
returns table
as return
  (
    select
      [MKTCOMMUNICATIONNAMESCHEMEPART].[NAMEPARTTYPECODE],
      [MKTCOMMUNICATIONNAMESCHEMEPART].[OPTIONTYPECODE],
      [MKTCOMMUNICATIONNAMESCHEMEPART].[VALUE],
      [MKTCOMMUNICATIONNAMESCHEMEPART].[SEPARATORTYPECODE],
      [MKTCOMMUNICATIONNAMESCHEMEPART].[SEQUENCE],
      [MKTCOMMUNICATIONNAMESCHEMEPART].[COMMUNICATIONEFFORTVALUE]
    from
      dbo.[MKTCOMMUNICATIONNAMESCHEME]
      inner join dbo.[MKTCOMMUNICATIONNAMESCHEMEPART] on [MKTCOMMUNICATIONNAMESCHEME].[ID] = [MKTCOMMUNICATIONNAMESCHEMEPART].[MKTCOMMUNICATIONNAMESCHEMEID]
    where
      [MKTCOMMUNICATIONNAMESCHEME].[MKTSEGMENTATIONID] = @SEGMENTATIONID 
  );