spGetECardTemplates

CREATE procedure [dbo].[spGetECardTemplates] (@ClientSitesID int, @categoryID int)
as
    set nocount on;

    select
        et.ID ECardTemplateID, 
        coalesce(etf.ID, -1) ECardTemplateFolderID, 
        et.Name
    from 
        dbo.ECardTemplate et
        left outer join dbo.ECardTemplateFolder etf on etf.ECardTemplateID = et.ID
    where
        et.ClientSitesID = @ClientSitesID
        and et.deleted = 0
        and et.IsSample = 0
        and (etf.SiteFoldersID = @categoryID or (etf.SiteFoldersID is null and @categoryID = -1))
    ORDER BY
        et.Name;