spLoadRecord_SiteVolunteerOps

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