Michael Meierruth (3/10/2011)

---

Jeff,
Neat stuff on hierarchies!
One thing that's confusing me is the use of the back slash and how it orders.
Thus in the script below, why do I get two different ordering results when I order on c1 as opposed to c2?

select *
from
  (
  select 'AA' c1,CAST('AA' as binary(4)) c2
  union all
  select 'A\',CAST('A\' as binary(4))
  ) t
order by c1

Jason-299789 (3/10/2011)

---

Nice Article Jeff, and having spent a lot of time recently working with them its good to see alternative solutions.

One common problem is people come across is when they have to flatten the hierarchy for data warehouses, eg Each level of the tree in a seperate column, and each row containing the entire tree for that Leaf node.

ekoner (3/10/2011)

---

Really enjoyed this article, it explained the use of the CTE very well. Great work as usual Jeff.