Common Table ExpressionsThis group of articles looks how to use Common Table Expressions or CTEs in SQL Server. Title Author Date SQL CTE Examples for Time Series Analysis Rick Dobson2026-06-04 SQL Server CTE Examples Ryan Kennedy2026-05-14 Find Duplicate Rows in SQL Server with a CTE Rick Dobson2026-04-21 SQL Generate Date Examples with Recursive CTE and Stored Procedure Rick Dobson2025-08-29 Troubleshoot Chained SQL Server CTE Jared Westover2025-01-02 Recursive Common Table Expression in SQL Server Examples Jared Westover2023-11-21 Recursive Queries using Common Table Expressions (CTE) in SQL Server Edwin Sarmiento2021-10-06 SQL Server Common Table Expressions (CTE) usage and examples Jayendra Viswanathan2018-03-27