For those of you who may require a database solution for extracting hierarchical data with SQL, I have published a new article that provides a very simply but working solution for your situations. It is by far not the most advanced or even possibly the most efficient solution for such a problem but as far as my testing with it goes, it does provide an accurate way for extracting hierarchical data from a SQL RDBMS database with such extractions based upon the primary or master key of a hierarchical data segment.
You may read the article at the following link…
Please let me know your comments or suggestions to this piece if it can be enhanced in any way.
Enjoy… 