spGetNewsletters

Parameters

Parameter	Parameter Type	Mode	Description
@ClientsID	int	IN
@ClientSitesID	int	IN

Definition

Copy


CREATE  procedure [dbo].[spGetNewsletters]
(
@ClientsID int,
@ClientSitesID int = NULL
)

as

select 
    ID, 
    Name, 
    Description, 
    Guid, 
    FromAddress, 
    FromDisplayName, 
    Subject, 
    Priority, 
    ReplyAddress, 
    ReturnReceipt, 
    ReturnReceiptAddress, 
    ForwardDSN, 
    ForwardDSNAddress
from dbo.EmailTemplate
where ClientsID = @ClientsID
and (@ClientSitesID is null
    or ClientSitesID = @ClientSitesID)
and type=2
and deleted=0
order by Name