spLoadRecord_ECardPart

CREATE procedure [dbo].[spLoadRecord_ECardPart] (@PKID int) as
    set nocount on;
    select 
        ID,
        SiteContentID,
        MaxHeight,
        MaxWidth,
        MaxRecipients,
        EmailTemplateID,
        BrowseCategories,
        ClientDonationsID,
        UseRichTextMessage,
        DisplayAllAsSingleFields,
        RequireRecipientName
    from dbo.ECardPart 
    where ID = @PKID;

    select 
        t.ID ECardTemplateID,
        coalesce(tf.ID, -1) ECardTemplateFolderID,
        t.Caption,
        coalesce(sf.FolderID, -1) CategoryID,
        coalesce(sf.FolderName, '') CategoryName
    from 
        dbo.ECardPartTemplate pt
        inner join dbo.ECardTemplate t on t.ID = pt.ECardTemplateID
        left outer join dbo.ECardTemplateFolder tf on tf.SiteFoldersID = pt.SiteFoldersID And tf.ECardTemplateID = t.ID
        left outer join dbo.SiteFolders sf on sf.FolderID = tf.SiteFoldersID
    where 
        pt.ECardPartID = @PKID;