spLoadRecord_SiteNotes

            CREATE PROCEDURE dbo.spLoadRecord_SiteNotes
            (
                @PKID                int
            )
            AS
            BEGIN
                SELECT n.*, c.Title AS Name, c.Guid, c.OwnerID 
                  FROM SiteNotes n
                  JOIN SiteContent c ON n.ContentID = c.ID
                 WHERE n.ContentID = @PKID
            END