DECLARE @idoc int, @myXml xml

SET @myXml = '<Author xmlns:xsi="..." xmlns:xsd="..." version="1">
  <Benefits>
    <Benefit Name="HospitalizationLimit" Value="500000"/>
    <Benefit Name="MedicalConsultationLimit" Value="12000"/>
    <Benefit Name="LifeInsuranceCoverage" Value="1000000"/>
    <Benefit Name="MonthlyTelephone" Value ="5000"/>
    <Benefit Name="DependentMemberCount" Value="5"/>
    ...
  </Benefits>
</Author>'

EXEC sp_xml_preparedocument @idoc OUTPUT, @myXml

SELECT *
FROM OPENXML ( @idoc, '/Author/Benefits', 2 )
WITH (
   HospitilizationLimit int './Benefit[@Name="HospitalizationLimit"]/@Value',
   MedicalConsultationLimit int './Benefit[@Name="MedicalConsultationLimit"]/@Value'
)

EXEC sp_xml_removedocument @idoc

<Products>
    <Product ID="123" Name="Male Bicycle" Amount="1">
        <Product ID="988" Name="Male Frame" Amount="1"/>
        <Product ID="501" Name="Wheel" Amount="2">
            <Product ID="450" Name="Spoke" Amount="50"/>
            <Product ID="490" Name="Rim" Amount="1"/>
        </Product>
        ...
    </Product>
    <Product ID="234" Name="Female Bicycle" Amount="1">
        <Product ID="998" Name="Female Frame" Amount="1"/>
        <Product ID="501" Name="Wheel" Amount="2">
            <Product ID="450" Name="Spoke" Amount="50"/>
            <Product ID="490" Name="Rim" Amount="1"/>
        </Product>
        ...
    </Product>
</Products>