Recursive Joins or Parent/Child Trees

By Bill Graziano on 15 September 2000 | 0 Comments | Tags: JOINs

Patrick was the most recent person to ask about using SQL Server to return the rows based on a parent child relationship (like a message board). Our own sqlguru wrote two articles on this not too long ago.

These articles are were originally posted on The first article (Performing Recursive Joins) covers the basics. Performing Complete Recursive Joins is the follow up article with more depth.

If you are planning a message board and wanting to maximize your use of SQL Server these articles will tell you what you can and can't do.

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Additional Criteria in the JOIN Clause (16 September 2002)

Other Recent Forum Posts

Importing an Excel file with a field needs format (0 Replies)

re-added user but cannot assign User Mapping (2 Replies)

SQL Database Issue (1 Reply)

Traditional Approach Vs Property Bag Tables Advice (2 Replies)

Get data from last month (5 Replies)

Msg 4104 (19 Replies)

Overlapping Date Ranges - Remove dup Permutations (5 Replies)

SQL Server Distribution Synchronisation Error (1 Reply)

Subscribe to

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers. Articles via RSS Weblog via RSS

- Advertisement -