Re: recursive to tree conversion?
Posted in 1996
Scott Gray (gray@voicenet.com) wrote: : There are some *very* nice algorithms for representing hierarchical : structures in a relational database using only base SQL92 features : (without cursors or recursion), which I have had great success with : in the past. I would recommend reading "SQL for Smarties" for : some examples. : If there is sufficient interest, I can provide some examples. Please do! -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+