Skip to content

Common Table Expressions (CTE)

Common Table Expressions

Have you ever wanted to create a recursive query but didn’t see how to do it? Do you have complex query with logs of subqueries that could be cleaned up with a CTE?

Through this Common Table Expressions course you will learn everything needed to start using CTE’s.


Common table expressions

You get full access to my Common Table Expressions book, along with sample code to support the queries shown in the book. You can download this as a PDF and start reading today. Over 250 pages of content all about TSQL and Common Table Expressions.

Once you have mastered the CTE you may never look at a query the same again.


Other SQL Server CTE Material, Posts, and Samples On This Site

CTE Hierarchy compared to the alternative

Recursive CTE’s

Calculating Factorials with a Recursive CTE

Fibonacci Sequence

CTE – With An Insert Statement

Generating a Tree Path with a CTE

CTE Query Performance

Multiple CTE’s in a single Query

Recursive CTE’s

CTE Category on this site

CTE Tag on this site

 CTE Presentations

SQL Saturday 166 in Olympia WA

SQL Saturday 172 in Portland Oregon

A Great Day at SQL Saturday 108 in Redmond.

SQL Saturday 108 in Redmond WA

SQL Saturday 114 in Vancouver BC

Getting Help from Steve and the Team

Contact us for your Free 30 minute consultation OR
schedule your appointment now.

Leave a Reply

Your email address will not be published. Required fields are marked *