<"menu" elements which have "menu" child elements?
Exactly.
At any level I would want to have parent nodes shown first.

"Martin Honnen" <mahotrash@y...> wrote in message 
news:e1fNcWK2JHA.3812@T......
> Markgoldin wrote:
>> < How do you determine that something is a folder?
>> That is the question.
>> After transforming that XML I am getting an hierarchical XML - the one 
>> with folders.
>> So, my initial thought was to sort the result using a new column added by 
>> transformation.
>> That column could have 1 for a folder and 0 for a child.
>
> The transformation result looks like this:
>
> <menu name="United Feather and Down" menuid="1" parentid="" link="" 
> line_id="" dept_id="" salesrepid="0" category="0">
>   <menu name="Customer Service" menuid="20" parentid="1" link="" 
> line_id="" dept_id="" salesrepid="0" category="4">
>     <menu name="Current Inventory" menuid="48" parentid="20" link="" 
> line_id="" dept_id="" salesrepid="0" category="4">
>       <menu name="Price Lists" menuid="50" parentid="48" link="" 
> line_id="" dept_id="" salesrepid="0" category="4" />
>       <menu name="Sku Attributes Reporting" menuid="47" parentid="48" 
> link="http://ufd-sql2008test/ReportServer?%2fskuattributesFG&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ExcludeOnHand= 
> " line_id="" dept_id="" salesrepid="0" category="4" />
>       <menu name="Sku Price List Preparation" menuid="49" parentid="48" 
> link="" line_id="" dept_id="" salesrepid="0" category="4" />
>     </menu>
>     <menu name="Customer Details" menuid="67" parentid="20" link="" 
> line_id="" dept_id="" salesrepid="0" category="4" />
>     <menu name="Customer Order Status" menuid="61" parentid="20" 
> link="http://ufd-sql2008test/ReportServer?%2fCustomerPoStatus&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno=&amp;SalesOrder=&amp;CustomerPO=&amp;Sku=&amp;OrderDate=&amp;ShipDateFrom=&amp;ShipDateTo= 
> " line_id="" dept_id="" salesrepid="0" category="4" />
>     <menu name="Customer Reporting" menuid="24" parentid="20" link="" 
> line_id="" dept_id="" salesrepid="0" category="4">
>       <menu name="Adam Briel" menuid="91" parentid="24" link="  " 
> line_id="" dept_id="" salesrepid="670" category="4" />
>       <menu name="Betty Mazon" menuid="83" parentid="24" link="  " 
> line_id="" dept_id="" salesrepid="325" category="4" />
>       <menu name="Christina Martinez" menuid="93" parentid="24" link=" " 
> line_id="" dept_id="" salesrepid="625" category="4" />
>       <menu name="Susan Finnane" menuid="95" parentid="24" link="  " 
> line_id="" dept_id="" salesrepid="375" category="4" />
>       <menu name="Yoori Lee" menuid="90" parentid="24" link="  " 
> line_id="" dept_id="" salesrepid="650" category="4" />
>     </menu>
>     <menu name="Pick Plan Status" menuid="62" parentid="20" 
> link="http://ufd-sql2008test/ReportServer?%2fPPStatus&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno= 
> " line_id="" dept_id="" salesrepid="0" category="4" />
>     <menu name="Product LookUp" menuid="55" parentid="20" 
> link="http://ufd-sql2008test/ReportServer?%2fCustserviceOpenOrders&amp;rs:Command=Render&amp;rc:Parameters=false&amp;rc:Zoom=100&amp;ccustno= 
> " line_id="" dept_id="" salesrepid="0" category="4" />
>   </menu>
> </menu>
>
> What do you consider a "folder" in there? The "menu" elements which have 
> "menu" child elements?
>
> -- 
>
> Martin Honnen --- MVP XML
> http://msmvps.com/blogs/martin_honnen/