Return to Recursive Joins or Parent/Child Trees
Recursive Joins or Parent/Child Trees
Written by Bill Graziano on 15 September 2000
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 4GuysFromRolla.com. 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.