DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: hierarchial tree / query

  1. 06-07-2006, 06:38 PM #1
    arun_m16
    arun_m16 is offline Junior Member
    Join Date
    Jul 2000
    Posts
    23

    hierarchial tree / query

    Data in the following format

    LEVEL COMPANY LVLSEQ LEVELIDNO

    4000 V1 50
    3000 V1 40 4000
    3001 V1 40 4001
    3001 V1 40 4002
    4000 V1 30 3000
    4001 V1 30 3001
    3000 V1 10 1000
    3001 V1 10 1001
    4002 V1 30 3002
    3002 V1 10 1003

    LVLSEQ will only have 50,40,30,10.
    Need some thoughts to diplay this data as inverted tree or flattened data ...
    Reply With Quote Reply With Quote
  2. 06-08-2006, 12:52 PM #2
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the output you want?

    Tamil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width