Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004

    Unanswered: Recursive data with multiple hierarchical level

    There is a scenario, where user are associated with different groups and groups have super-groups and sub-groups.

    The work assignments are divided into multiple tasks, which could be assigned at user level as well as group level, with could be a sub-group or super-group or both.

    I'm able to do my select using rdbms-specific queries but unable to find a common sql, which would work for DB2, Oracle and SQL server.

    Any input is welcome. Thanks.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    are you talking about Oracle's CONNECT BY feature?

    you will not be able to do the same thing in other databases | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2004
    If you post your query, or a simplified version thereof, maybe someone could convert it to standard SQL.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting

  4. #4
    Join Date
    Oct 2004
    Thanks for the responses!

    Yes. 'CONNECT BY PRIOR' was one the issue. But, the issue is resolved by creating a 'view' to list work-items and associated users.

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts