Recursive queries are something I have used many, many times over the years to build dynamic, n-tiered hierarchies. Oracle’s CONNECT BY PRIOR is awesome.

Does anyone know if this is possible in SQL Server or MySQL?

From what I understand, stored procedures would need to be used in MySQL and SQL Server to accomplish what Oracle does in one SQL statement with CONNECT BY PRIOR. I need to dig into the other databases a bit further to verify, but I am interested in any elegant solutions people have come up with if you would like to share.

Related Information:

1. Oracle Database vs Sun MySQL

   Well, this is a topic we have reviewed numerous times over the years for projects and customers. The fact is,...

2. Staging Data with MySQL, CSVed, and XAMPP

   The Task: Take and load, using MySQL, a flatfile of over 450 colums and over 145,000 rows of data and...

3. TOAD for Oracle 9 or TOAD 10 - 64-bit Windows - ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

   I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x,...

4. Google Apps Reporting API - Not quite this easy with Exchange

   I have been somewhat enamored by Google Apps and its potential. Many enterprises have been happy with Exchange for mail,...

5. Oracle Application Server Startup and Shutdown Script Generator - FREE

   Complete the below to receive scripts to automatically startup and shutdown your Oracle Application Server 10.1.2.x or 10.1.3.x midtier environment....

6. Oracle IdM - SAML SSO with Google Apps

   We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against...