Practical SQL: Don't Be Afraid of Recursion by Joe Pluta

A word that sometimes strikes fear into the programmers, "recursion" is sometimes the only tool for the job, and this article shows you how to recurse in SQL.

http://www.mcpressonline.com/programming/sql/practical-sql-dont-be-afraid-of-recursion.html
The above link may require a free, or paid, registration to view the article.

[report a broken link by clicking here]