spLoadRecord_ContentComparisonPart

      CREATE PROCEDURE [dbo].[spLoadRecord_ContentComparisonPart](@CID int)
      AS
      SELECT ccp.ID AS CCPID, ccp.TargetPID, ccp.StartedDate, ccp.EndedDate, sc.Title, sc.ID AS SCID, ccp.Threshold AS Threshold FROM ContentComparisonPart ccp
      INNER JOIN sitecontent sc ON sc.ID = ccp.sitecontentid
      WHERE ccp.SiteContentID=@CID