re: World's Simplest Recursive CTE?

DonK — Fri, 04 Sep 2009 22:56:19 GMT

Sanford,

Yep, I like the changes. Not the simplest, but indeed a better example.

In defense, my goal was to be the simplest. :-)

Thanks!

Don

Sanford — Fri, 04 Sep 2009 19:26:35 GMT

I modified your code slightly. This is slightly more complex, but also a better example:

WITH SimpleCTE(Number) AS

(

SELECT 1

UNION ALL

SELECT Number+1 FROM SimpleCTE WHERE Number<10

)

SELECT * FROM SimpleCTE

Don Kiely - All Comments