Re: Parent/Child concept in SQl tables - How do I
From: Joe Celko (joe.celko_at_northface.edu)
Date: 04/01/04
- Next message: Joe Celko: "Re: Alias and Where clause problem"
- Previous message: Joe Celko: "Re: How do you progammatically add a line to a stored procedure"
- In reply to: Mark Andrews: "Parent/Child concept in SQl tables - How do I"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 01 Apr 2004 14:16:57 -0800
>> What is the best approach to pull information from a table which has
an ID and a ParentID? a directory tree structure <<
You have the worst design of all the approaches I found. Here is the
link on Amazon.com for my new book on "Trees & Hierarchies in SQL"
http://www.amazon.com/exec/obidos/tg/detail/-/1558609202/qid=1080772873/
sr=1-1/ref=sr_1_1/102-7683601-6345721?v=glance&s=books#product-details
--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Joe Celko: "Re: Alias and Where clause problem"
- Previous message: Joe Celko: "Re: How do you progammatically add a line to a stored procedure"
- In reply to: Mark Andrews: "Parent/Child concept in SQl tables - How do I"
- Messages sorted by: [ date ] [ thread ]
