spLoadRecord_SiteProfilePhotoForm

CREATE PROCEDURE [dbo].[spLoadRecord_SiteProfilePhotoForm]
(
    @PKID int
)
AS
    SELECT 
        pp.ContentId,
        pp.CaptionEditable, 
        pp.DefaultCaption,
        pp.PhotoEditable,
        pp.ApprovalRequired,
        pp.ThumbSize, 
        ISNULL(f.FolderID, 0) AS CategoryFolderID,
        pp.AfterUpdatePageID,
        pp.LargeSize,
        pp.TAGCODEID
      FROM dbo.SiteProfilePhotoForm pp
      LEFT OUTER JOIN dbo.SiteFolders f ON pp.CategoryFolderID = f.FolderID
     WHERE pp.ContentID = @PKID

    RETURN