UFN_MKTMEMBERSHIPMAILINGTEMPLATESOURCECODEPART_GETITEMLIST2

CREATE function dbo.[UFN_MKTMEMBERSHIPMAILINGTEMPLATESOURCECODEPART_GETITEMLIST2]
(
  @MEMBERSHIPMAILINGTEMPLATEID uniqueidentifier
)
returns table
as
  return
  (
    select
      [MKTSOURCECODEPART].[ID],
      [MKTSOURCECODEPARTDEFINITION].[ITEMTYPECODE] as [SOURCECODEPARTTYPE],
      [MKTSOURCECODEITEM].[ID] as [SOURCECODEITEMID],
      [MKTSOURCECODEPARTDEFINITION].[ID] as [PARTDEFINITIONID],
      [MKTSOURCECODEPARTDEFINITION].[NAME] as [PARTDEFINITIONNAME],
      [MKTSOURCECODEPART].[PARTDEFINITIONVALUESID],
      [MKTSOURCECODEPART].[CODE],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[REGEX] as [CODEREGEX],
      [MKTSOURCECODEITEM].[SEQUENCE]
    from dbo.[MKTSOURCECODEPART]
    inner join dbo.[MKTSOURCECODEITEM] on [MKTSOURCECODEITEM].[ID] = [MKTSOURCECODEPART].[SOURCECODEITEMID]
    inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITION].[ID] = [MKTSOURCECODEITEM].[MKTSOURCECODEPARTDEFINITIONID]
    inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] = [MKTSOURCECODEPART].[PARTDEFINITIONVALUESID]
    where [MKTSOURCECODEPART].[MEMBERSHIPMAILINGTEMPLATEID] = @MEMBERSHIPMAILINGTEMPLATEID
  );