Not sure what example you're asking from me. I gave you all technical details, so you can work it out from there. I challenged you to come up with a SET ORIENTED approach to compare. I'm willing to give you mine later to give you some time.

I posted a few minutes ago a reference to a very simple hierarchical table, mainly just to establish the mechanics for recursive querying. Since you said that hierarchical problems are best helped with a row-oriented approach, I was looking for one that you felt demonstrated that.

Kevin