Similar Posts
Recursive CTE how to concatenate the results onto a single line
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 – 1
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…
Recursive CTE: The Elegance of Simplicity in SQL – 2
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….
Skillup i Power Days 2024 – Interview – intro
Intervista SkillUP – parte introduttiva
Recursive CTE: The Elegance of Simplicity in SQL – 3
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…
SkillUP™ – experience in action
Devi sostituire le ACG con nuovo ERP? In realtà delle ACG è rimasto il nome ma negli anni sono proliferati programmi e archivi collaterali che, se non considerati e correttamente gestiti, creeranno grossi problemi nella migrazione… Skillup i Power Days…