Common Table Expressions

Download PDF

Classes available online or onsite.

I offer a 1 or 2 hour online or onsite class on Common Table Expressions.  To request a class use the Contact Steve page, please include your contact information including your email and a phone number.  I will get back to you to schedule a class.

Presentation Overview – Common Table Expressions

  1. Introduction
  2. Prerequisites
  3. What is a Common Table Expression
  4. Simple CTE
  5. CTE – Subquery Re-use
  6. Recursive CTE
  7. Multiple CTE
  8. CTE Common Uses
  9. CTE for Math Geeks
  10. CTE Fact or Fiction – Debunking

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

Leave a Reply

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


Time limit is exhausted. Please reload CAPTCHA.