spDEBUG_forceContentComparisonStatsUpdate

  CREATE procedure [dbo].[spDEBUG_forceContentComparisonStatsUpdate] AS
  DECLARE @CCStatsTable table(PageID int, Clickthroughs int, CCPRelID int)
  INSERT INTO @CCStatsTable(PageID, Clickthroughs, CCPRelID)
  SELECT s.PageID,
  count(s.PageID) as Clickthroughs,
  cc.ID
  FROM
  [dbo].ContentComparisons cc
  INNER JOIN [dbo].[Stats] s ON s.CCPRelID = cc.ID
  INNER JOIN [dbo].ContentComparisonPart ccp ON cc.CCPID = ccp.ID
  GROUP BY cc.ID, s.PageID


  --Update the clickthrough counts for any existing parts
  UPDATE [dbo].ContentComparisonStats
  SET
  [dbo].ContentComparisonStats.Clickthroughs = t.Clickthroughs
  FROM
  @CCStatsTable t, [dbo].ContentComparisonStats
  WHERE
  [dbo].ContentComparisonStats.CCPRelID = t.CCPRelID
  AND [dbo].ContentComparisonStats.PageID = t.PageID

  --For new parts, insert
  INSERT INTO [dbo].ContentComparisonStats(CCPRelID, Clickthroughs, PageID)
  SELECT
  t.CCPRelID,
  t.Clickthroughs,
  t.PageID
  FROM
  @CCStatsTable t
  WHERE
  NOT EXISTS (SELECT * FROM [dbo].ContentComparisonStats ccs WHERE t.CCPRelID=ccs.CCPRelID AND t.PageID=ccs.PageID)