Common Table Expressions

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 *


× 2 = eight

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at with my newsletter.
Newsletter signup form.

Stedman Solutions