var data =**'<root xmlns:json="http://james.newtonking.com/projects/json">
  <row json:Array="true" RowNumber="1">
    <Column json:Array="true" Name="Number" Value="1" />
    <Column json:Array="true" Name="HourFrom" Value="13.2" />
    <Column json:Array="true" Name="HourTo" Value="13.3" />
    <Column json:Array="true" Name="Rate" Value="0.895" />
  </row>
  <row json:Array="true" RowNumber="2">
    <Column json:Array="true" Name="Number" Value="1" />
    <Column json:Array="true" Name="HourFrom" Value="13.3" />
    <Column json:Array="true" Name="HourTo" Value="13.4" />
    <Column json:Array="true" Name="Rate" Value="0.907" />
  </row>
</root>'**

  **Temp table creation**

    CREATE TABLE #xmltable(
                           Id INT Identity (1,1)  PRIMARY KEY CLUSTERED,
                           DataValue XML
                          );


    CREATE PRIMARY XML INDEX indexratesheet ON #xmltable
                    (
                      DataValue
                     )
    **Inserting data into table**

    INSERT INTO (DataValue ) VALUES(data )

    **updating the XML string in the table**

    DECLARE @i INT 1
    WHILE(@i<=1000)
    BEGIN
         UPDATE #xmltable SET DataValue.modify('insert <Column Name="ValidationComments" Value="{sql:variable("@validationcomments")}"></Column>
                              into (/root/row[@i=sql:variable("@i")])[1]')
   SET @i=@i+1
   END