Recursive CTE

Recursive CTE how to concatenate the results onto a single line

22 January 202412 February 2024 Manage AS400 with SQL, More in depth, Tips and Tricks

Below are the articles in the CTE series (including this current one): Definition of the context Let’s suppose we have a table that reports the results of nightly interface processing, as in the following example: INT RESULT 0011 0012 0013…

Recursive CTE: The Elegance of Simplicity in SQL – 3

15 January 202412 February 2024 As400 Architecture, Manage AS400 with SQL, More in depth

Introduction As we have already seen in other Articles, Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400), but also present in many other versions on other non-IBM systems, represent a powerful and flexible tool for creating temporary queries…

Recursive CTE: The Elegance of Simplicity in SQL – 2

11 January 202412 February 2024 Manage AS400 with SQL, More in depth, As400 Architecture

Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400) are a powerful and versatile tool for processing temporary, reusable queries. They help simplify and increase the clarity of complex SQL queries, making them more manageable and easier to understand….

Recursive CTE: The Elegance of Simplicity in SQL – 1

10 January 202412 February 2024 Manage AS400 with SQL, More in depth

Common Table Expressions (CTE) in SQL on IBM iSeries (AS/400) are a powerful and flexible tool for creating temporary, reusable queries, simplifying and improving the readability of complex SQL queries. Below are the articles in the CTE series (including this…