RE: SQL Procedure- Hierarchy listing of table content

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 12:31:01 -0800

Also,

Maintaining Hierarchies
http://www.winnetmag.com/Article/ArticleID/8826/8826.html

Manipulating Hierarchies with UDFs
http://www.winnetmag.com/Article/ArticleID/16123/16123.html

AMB

"Alejandro Mesa" wrote:

> See "Expanding Hierarchies" in BOL. If you are interested in a method other
> thatb adjacency list then:
>
> Trees in SQL
> http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=397531
>
> Trees in SQL: Nested Sets and Materialized Path
> http://www.dbazine.com/tropashko4.shtml
>
> Joe Celko's Trees and Hierarchies in SQL for Smarties
> http://www.amazon.com/exec/obidos/tg/detail/-/1558609202/qid=1108585417/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/103-6312162-7087830?v=glance&s=books&n=507846
>
>
> AMB
>
> "Ludwig via SQLMonster.com" wrote:
>
> > Have an employee_tbl ( employee_id,, Manager_id), need a procedure or
> > function whose outcome will list the company hierarchy (top to buttom
> > regardless of the level depth) of Who reports to Who based on data in
> > Employee_tbl. i.e.
> >
> > John Doe
> > Jane Doe -----| kerry ---- | Bugsie--|Joe
> > | Marg | Klein
> > | Rose
> > Jack Hanna ---| Kelly
> > |Steve
> >
> > Martina Higis-|Patrick
> > |bernice
> >
> > Thanks in advance
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >