read xml string in sql server

declare @stringxml xml
 
set @stringxml ='
<NewDataSet>
  <Table1>
    <groupname>Superannuation Pension</groupname>
    <effectivedate>11/02/2012</effectivedate>
    <termdate>11/02/2012</termdate>
    <groupvalue>PE</groupvalue>
  </Table1>
  <Table1>
    <groupname>Family Pension</groupname>
    <effectivedate>11/02/2012</effectivedate>
    <termdate>11/02/2012</termdate>
    <groupvalue>PF</groupvalue>
  </Table1>
  <Table1>
    <groupname>Judges Pension</groupname>
    <effectivedate>11/02/2012</effectivedate>
    <termdate>11/02/2012</termdate>
    <groupvalue>PJ</groupvalue>
  </Table1>
  <Table2>
    <groupname>Pension Arrear</groupname>
    <effectivedate>11/02/2012</effectivedate>
    <termdate>11/02/2012</termdate>
    <groupvalue>tbllocationPJ</groupvalue>
  </Table2>
  <Table2>
    <groupname>First Pension</groupname>
    <effectivedate>11/02/2012</effectivedate>
    <termdate>11/02/2012</termdate>
    <groupvalue>tbllocationPE</groupvalue>
  </Table2>
  <Table2>
    <groupname>Leave Travel Concession</groupname>
    <effectivedate>11/02/2012</effectivedate>
    <termdate>11/02/2012</termdate>
    <groupvalue>tbllocationPF</groupvalue>
  </Table2>
</NewDataSet>'


Declare @intPointer int  
EXEC sp_xml_preparedocument @intPointer OUTPUT, @stringxml

SELECT * into #Table1 FROM OpenXml(@intPointer,'/NewDataSet/Table1',2)  
WITH (groupname varchar(100), effectivedate datetime, termdate datetime, groupvalue varchar(100))  

SELECT * FROM #Table1

EXEC sp_xml_removedocument @intPointer  

DROP TABLE #Table1