If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

Because why benchmark sql engines with boring aggregates when you can generate fractals? This project uses recursive Common Table Expressions (CTE) to calculate the Mandelbrot set entirely in SQL — no ...

Problem: Starting from the HR department head (dept_id = 1, manager_id is NULL), list all employees in that reporting chain (head + all direct/indirect reports).

Hey All,<BR><BR>Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table ...

OK, this is a bit odd but will be fun -- View image here: http://episteme.arstechnica.com/groupee_common/emoticons/icon_smile.gif --<br><br>I have 1 table.<br><br>Let ...