i ve been trying to execute the following query in my sql server
declare @doc int
declare @xmldoc nvarchar(1000)
set @xmldoc = N'<ROOT>
<customer customerID="JH01 contactName=John Henriot">
<order orderID = "1001" customerID="JH01"
orderDate = "2006-07-04T00:00:00">
<orderdetail productID="11" quantity="12"/>
<orderdetail productID="22" quantity="10"/>
</order>
</customer>
<customer customerID="SG01" customerName="steve Gonzler">
<order orderID="1002" customerID="SG01"
orderDate="2006-08-16T00:00:00">
<orderdetail productID="32" quantity="3"/>
</order>
</customer>
</ROOT> ...
Go to the complete details ...