Posted by markc600 on 11/22/06 22:12

This may help


SELECT n.value('.','nvarchar(100)') AS DeliveryAddress
FROM Sales
CROSS APPLY DeliverySchedule.nodes('declare default element namespace
"http://schemas.adventure-works.com/DeliverySchedule";
/DeliveryList/Delivery[1]/Address') D(n)

• Next in forum: Re: Shrinking database log used for mirroring
• Prev in forum: sql question
• Thread view: Re: Xquery Help SqlServer2005

[Reply to this message]