spGetContentInActiveComparisonTest

  CREATE PROCEDURE spGetContentInActiveComparisonTest
  AS
  SELECT
  cc.cid,
  sc.Title
  FROM
  [dbo].contentcomparisons cc
  INNER JOIN contentcomparisonpart ccp ON cc.ccpid = ccp.id
  INNER JOIN sitecontent sc ON sc.id = ccp.sitecontentid
  WHERE
  ccp.starteddate IS NOT NULL
  AND endeddate IS NULL