Points: 7059

7/11/2016 12:40:07 PM

CTE Example showing Recursion

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

I find it helpful to have a piece of sample code to start a new query, especially the complicated ones. Here is a very simple query demonstrating recursion and CTE (common table expressions)

I took the code directly from a Microsoft example, but simplified it greatly to better suit our main goal here - Rapid Application Development (RAD)


Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables