Try using OPEN xml:

Prerequisites: You should be able to query using xpath. See the below example

DECLARE @idoc int

DECLARE @doc varchar(1000)

SET @doc ='

<ROOT>

<Customer CustomerID="VINET" ContactName="Paul Henriot">

<Order...