UFN_MKTMARKETINGPLANTEMPLATE_GETITEMLIST

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