Posted by CK on 11/27/06 19:23

Thanks! I came up with this and it works.


SELECT DeliveryList.value('declare namespace
df="http://schemas.adventure-works.com/DeliverySchedule";
(/df:DeliveryList/df:Delivery/df:Address)[1]','nvarchar(100)')
DeliveryAddress
FROM Sales.DeliverySchedule


<markc600@hotmail.com> wrote in message
news:1164233567.073470.233360@m73g2000cwd.googlegroups.com...
> 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: Need Help to form the MDX-Statement
• Prev in forum: Re: How to export SQL Database properties
• Thread view: Re: Xquery Help SqlServer2005

[Reply to this message]