Walter,

In a prior post, you stated that "Solving problems that are hierarchical and nested in nature are best helped with a record oriented approach rather than a SET ORIENTED".

In response to this, I've posted another blog entry (www.TheBakersDozen.net) that covers the basics of recursive queries in SQL 2005.

Your thoughts on this? Any short and specific examples you'd like to offer?

Kevin