Ryerson has a cool picture of breadth first vs depth first traversal

http://www.ryerson.ca/~dgrimsha/courses/cps721/images/nBreadthFirst.gif

http://www.ryerson.ca/~dgrimsha/courses/cps721/nDepth.html

IS the breadth-first command available in SQL 2005?

with recursive itemlist(atitem,piece,qty,cost) AS

(select item_id,planning_item,1,0)

from titems

where item_id='AT1000000'

UNION ALL

SELECT item_id,piece,qty,qty*cost

From vInventory,tItems

where item_id=item_id)

Search Breadth First by item_id,Item_id

set order_column

SELECT piece,qty,cost from vInventroy

Order by Order_column;