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