spLoadRecord_ECardTemplate

CREATE PROCEDURE [dbo].[spLoadRecord_ECardTemplate] (@PKID int)
                AS
                    set nocount on;

                    -- result set #1
                    select 
                        ID, 
                        ClientSitesID, 
                        Name, 
                        Caption,
                        SubjectLine,
                        Type,
                        PreviewImage,
                        PreviewImageType,
                        PreviewImageModified,
                        HtmlContent,
                        OwnerID,
                        IsSample

                    from 
                        dbo.ECardTemplate 
                    where 
                        ID = @PKID;

                    -- result set #2
                    SELECT 
                        ectf.ECardTemplateID, 
                        ectf.SiteFoldersID, 
                        sf.FolderName 
                    FROM 
                        dbo.ECardTemplate ect
                        INNER JOIN dbo.ECardTemplateFolder ectf ON ectf.ECardTemplateID = ect.ID
                        INNER JOIN dbo.SiteFolders sf ON sf.FolderID = ectf.SiteFoldersID 
                    WHERE 
                        ect.ID = @PKID 
                    ORDER BY 
                        sf.FolderName;