;WITH new_Questions AS (
    SELECT  ParamValues.x1.value('itemID[1]'    , 'int'           ) AS itemID,
            ParamValues.x1.value('categoryID[1]', 'int'           ) AS categoryID,
            ParamValues.x1.value('question[1]'  , 'nvarchar(1000)') AS question,
            ParamValues.x1.value('sortID[1]'    , 'int'           ) AS sortID,
            GETDATE()                                               AS date,
            ParamValues.x1.value('modBy[1]'     , 'varchar(50)'   ) AS modBy
    FROM    @xml.nodes('/ranks/item') AS ParamValues(x1)
)
MERGE INTO editor_Questions AS old
USING new_Questions AS new
  ON (new.itemID = old.itemID)
WHEN MATCHED THEN UPDATE SET
  old.categoryID = new.categoryID,
  old.question   = new.question  ,
  old.date       = new.date      ,
  old.sortID     = new.sortID    ,
  old.modBy      = new.modBy
WHEN NOT MATCHED THEN 
  INSERT (    itemId,    categoryID,    question,    date,    sortID,    modBy)
  VALUES (new.itemId,new.categoryID,new.question,new.date,new.sortID,new.modBy);


SQL Server: update table from xml string
I'm looking for a library which do this :


Retrieve a JSON through an AJAX call
Populate table with the JSON
Update in real time the table with the JSON (call every x seconds) and only delete or hide the rows wich are deleted or insert the new rows.


/Editing after first answer

Ok i guess my first explanation was not good.
Retrieving through jquery a json and build a table is good, i could do that, but my request was more on the other part. 
I'm looking for a library to display the result in a special way. 
Let me explain. 
Json request 1 send : 
1;Tomato 2;Apple 3;Salad 4;Carot 

Json request 2 send : 
1;Tomato 3;Salad 4;Carot 5;Potatoes 

I would like the second row disapear with a effect (fadeOut) and the rows below move Up. For the row 5, i just want a new row appears with a fade in. 

Is that more clear ? 

Is there any livrary existing doing this ?

Thanks again

I'm doing it in PHP, but i hope to write all this in JS.

The user could just look the table and see the new rows appearing and the old rows deleting.

Any ideas or am i supposed to write it from scratch ?

Thanks a lots
