SQL Procedure- Hierarchy listing of table content

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ludwig via SQLMonster.com (forum_at_SQLMonster.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 20:17:45 GMT

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
Quantcast