spUpdateCCPContents

  CREATE PROCEDURE [dbo].[spUpdateCCPContents] (
  @CCPID int,
  @Contents nvarchar(max)
  )

  AS

  DELETE FROM [dbo].[ContentComparisons] WHERE CCPID = @CCPID

  DECLARE @XmlData xml;
  SET @Contents = REPLACE(@Contents, 'encoding="utf-16"',    '')
  SET @Contents = REPLACE(@Contents, 'encoding="utf-8"',    '')
  SET @XmlData = CAST(@Contents AS XML)

  INSERT INTO [dbo].[ContentComparisons]
  ([CCPID]
  ,[CID]
  ,[Selected]
  ,[NumDisplays]
  ,[Conversions])
  SELECT @CCPID as CCPID,
  CTIDs.cs.value('(int)[1]', 'int') as ID,
  CTIDs.cs.value('(int)[2]', 'int') as Selected,
  CTIDs.cs.value('(int)[3]', 'int') as NumDisplays,
  0 as Conversions
  FROM @XmlData.nodes('(/ArrayOfArrayOfInt/ArrayOfInt)') CTIDs(cs)