>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