UFN_GETDISTINCTEMAILINFOBYID

      create function dbo.UFN_GETDISTINCTEMAILINFOBYID
      (
          @ClientSitesID int, 
          @eMailID int
      )
      returns table as
      return (
        select distinct
          e.[ID] EmailID, 
          t.[Name], 
          e.Subject
        from 
          [dbo].[EmailTemplate] t inner join 
          [dbo].[Email] e on t.[id] = e.EmailTemplateID and t.ClientsID = @ClientSitesID and e.ID = @eMailID
      )