spSetSelectedContentComparison

  CREATE PROCEDURE [dbo].[spSetSelectedContentComparison]
  (
  @CCPRelID int
  )
  AS

  DECLARE @CCPID int
  SELECT @CCPID=CCPID FROM [dbo].ContentComparisons WHERE ID=@CCPRelID

  UPDATE [dbo].ContentComparisons
  SET Selected=0
  WHERE CCPID=@CCPID

  UPDATE [dbo].ContentComparisons
  SET Selected=1
  WHERE ID=@CCPRelID