UFN_MKTMARKETINGPLAN_GETTEMPLATEITEMLIST

CREATE function dbo.[UFN_MKTMARKETINGPLAN_GETTEMPLATEITEMLIST]
(
  @MARKETINGPLANID uniqueidentifier
)
/*
Returns a table of template items that have been assigned to the given MARKETINGPLANID
*/
returns table
as
  return (select
            [M].[ID],
            [M].[CAPTION],
            [M].[BACKCOLOR],
            [M].[FORECOLOR],
            [M].[CAPTIONCOLOR],
            [M].[LEVEL]
          from dbo.[MKTMARKETINGPLANITEMTEMPLATEITEM] [M]
          where [M].[MARKETINGPLANID] = @MARKETINGPLANID);