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/