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

    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
    Location
    Toronto, Canada
    Posts
    20,002
    are you talking about Oracle's CONNECT BY feature?

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

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    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
    __http://www.abis.be/

  4. #4
    Join Date
    Oct 2004
    Posts
    7
    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
  •