UFN_MKTCOMMUNICATIONNAMESCHEME_GETNAMEPARTS

CREATE function dbo.[UFN_MKTCOMMUNICATIONNAMESCHEME_GETNAMEPARTS]
(
  @MKTCOMMUNICATIONNAMESCHEMEID uniqueidentifier
)
returns table
as
  return
  (
    select 
      [ID],
      [NAMEPARTTYPECODE],
      [OPTIONTYPECODE],
      [VALUE],
      [SEPARATORTYPECODE],
      [SEQUENCE]
    from dbo.[MKTCOMMUNICATIONNAMESCHEMEPART]
    where [MKTCOMMUNICATIONNAMESCHEMEID] = @MKTCOMMUNICATIONNAMESCHEMEID 
  );