Some XQuery/SQL Server 2005 help please

[CK]

This query

SELECT DeliveryList.qu ery('declare default element namespace

http://schemas.adventure-works.com/DeliverySchedule;

<DeliveryRout e>
<RouteNo>{ sql:column("D.D eliveryRoute") }</RouteNo>
for a$ in /DeliveryList/Delivery/Address
return
<Address>a$</Address>
</DeliveryRoute>' )
as Result
FROM Sales.DeliveryS chedule D

Returns this XML

<DeliveryRout e xmlns="http://schemas.adventu re-works.com/DeliverySchedul e">
<RouteNo>3</RouteNo>
for a$ in /DeliveryList/Delivery/Address
return
<Address>a$</Address></DeliveryRoute>

I need it to return this XML
<DeliveryRout e xmlns="http://schemas.adventu re-works.com/DeliverySchedul e>

<RouteNo<3>/RouteNo>

<Address>6126 North Sixth Street, Rockhampton</Address>

<Address>6445 Cashew Street, Rockhampton</Address>

</DeiveryRoute>



What am I doing wrong? Any ideas? All help is appreciated.

TIA, ~CK

[CK]

Re: Some XQuery/SQL Server 2005 help please

Here is the original XML Doc
<?xml version="1.0" ?>
- <DeliveryList xmlns="http://schemas.adventu re-works.com/DeliverySchedul e">
- <Delivery SalesOrderID="4 3659">
<CustomerName>S teve Schmidt</CustomerName>
<Address>6126 North Sixth Street, Rockhampton</Address>
</Delivery>
- <Delivery SalesOrderID="4 3660">
<CustomerName>T ony Lopez</CustomerName>
<Address>6445 Cashew Street, Rockhampton</Address>
</Delivery>
</DeliveryList>

"CK" <c_kettenbach@h otmail.comwrote in message
news:DqHah.6841 $yf7.2082@newss vr21.news.prodi gy.net...

This query
>
SELECT DeliveryList.qu ery('declare default element namespace

http://schemas.adventure-works.com/DeliverySchedule;

<DeliveryRout e>
<RouteNo>{ sql:column("D.D eliveryRoute") }</RouteNo>
for a$ in /DeliveryList/Delivery/Address
return
<Address>a$</Address>
</DeliveryRoute>' )
as Result
FROM Sales.DeliveryS chedule D
>
Returns this XML
>
<DeliveryRout e
xmlns="http://schemas.adventu re-works.com/DeliverySchedul e">
<RouteNo>3</RouteNo>
for a$ in /DeliveryList/Delivery/Address
return
<Address>a$</Address></DeliveryRoute>
>
I need it to return this XML
<DeliveryRout e xmlns="http://schemas.adventu re-works.com/DeliverySchedul e>
>
<RouteNo<3>/RouteNo>
>
<Address>6126 North Sixth Street, Rockhampton</Address>
>
<Address>6445 Cashew Street, Rockhampton</Address>
>
</DeiveryRoute>
>
>
>
What am I doing wrong? Any ideas? All help is appreciated.
>
TIA, ~CK
>
>
>
>