spLoadRecord_SiteImages

        CREATE procedure[dbo].[spLoadRecord_SiteImages]
        (
            @PKID int
        )
        as
        begin
            set nocount on

            -- result set #1
            select 
                SiteImages.id, 
                clientsitesid, 
                name, 
                filename, 
                uploadfilename, 
                imagetype, 
                imagesize, 
                imagecontent, 
                guid, 
                ownerid, 
                deleted, 
                type, 
                caption, 
                approved,
                private,
                dbo.fnLastModifiedDate(Guid) LastModifiedDate,
                iai.ImageAlbumID,
                iai.Sequence,
                photographer,
                photodatetaken,
                createdate,
                URL,
                ThumbX,
                ThumbY,
                ThumbLength
            from dbo.SiteImages 
            left outer join ImageAlbum_Images iai ON iai.SiteImageID = SiteImages.ID 
            where SiteImages.ID = @PKID

            --result set #2
            select
                SIF.SiteImageID, 
                SIF.SiteFolderID, 
                SF.FolderName 
            from dbo.SiteImages SI
        inner join dbo.SiteImageFolders SIF on SIF.SiteImageID = SI.ID
            inner join dbo.SiteFolders SF on SF.FolderID = SIF.SiteFolderID 
            where SI.ID = @PKID 
            order by SF.FolderName
        end