spGetEmailsForDataSourceID

CREATE procedure [dbo].[spGetEmailsForDataSourceID]
    (
        @DataSourceID int,
        @IncludedDeleted bit 
    )

    as 
    select  e.[ID]
      ,e.[EmailTemplateID]
      ,e.[Name]
      ,e.[Description]
      ,e.[OwnerID]
      ,e.[Deleted]
      ,e.[Guid]
      ,e.[Type]
      ,e.[Status]
      ,e.[ContentHTML]
      ,e.[ContentText]
      ,e.[FromAddress]
      ,e.[FromDisplayName]
      ,e.[Subject]
      ,e.[Priority]
      ,e.[ReplyAddress]
      ,e.[ReturnReceipt]
      ,e.[ReturnReceiptAddress]
      ,e.[ForwardDSN]
      ,e.[ForwardDSNAddress]
      ,e.[SendAfterDate]
      ,e.[CreateDate]
    from Email e inner join emailtemplate et on e.EmailTemplateID = et.[ID]
    where et.DataSourceID = @DataSourceID
    and e.deleted in (0, @IncludedDeleted)
    order by [e].[name]