Question about recursive or nested SQL call

[jfield817]

I have a table Organizations with Orgid and Parentid as fields ... as org and its parent org)

If the Parentid is not null, then Orgid has a parent record
with its own Orgid ...and on up the chain..
If the Parentid is null then that record has no parents.
and is the top org for that group.

How do I retrieve all the records up the chain for
a particular Orgid ...

Some type of nested ..query ?

Thanks
John

 

[TomSark]

There are a couple of articles in books-online about this. Index on "Expandind Hierarchies" and "Expanding Networks" do learn how to do this. No recursion is required... Tom Davis
tdavis@sark.com

http://www.sarkdallas.com