|
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)
Navigation:
[Reply to this message]
|