General information
Forum:
Microsoft SQL Server
>Can someone show how to setup table(s) to make querying hierarchical data easier and perhaps share a simple SQL to query it?
>
>For example, if I wanted to setup and lstore family geneology info. then later query "all" descendants of a particular person within the tree how would I go about doing this? TIA.
SQL Server isn't supper with hieracial data. What are you using client side? ADO has some built in stuff to help retrieve data as a hierarcy.
I would assume you would store the data and in your primary table you would have a self-reference.
BOb
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only