Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Craig Hatley Everybody Reports to Somebody RE: Everybody Reports to Somebody

  • June 4, 2007 at 2:54 am

    #710542

    Oracle has "Connect by prior"

    select * from person connect by prior id=supervisor_id

    .. it makes traversing hierarchies trivial.

    I was hoping it would appear in SS2005...