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

10 Responses to Common Table Expressions

  1. Pingback: » Can we use CTEs use in SSRS? Steve Stedman

  2. Pingback: » TSQL 2012 – OFFSET and FETCH Steve Stedman

  3. Pingback: » Using a CTE to Split a String Into Rows Steve Stedman

  4. Pingback: » Using a CTE in a Function to Split Up a Query String Steve Stedman

  5. Pingback: » SQL Lunch UK Steve Stedman

  6. Pingback: » Sessions for Code Camp in 2 weeks Steve Stedman

  7. Pingback: » Home after Seattle (Redmond) Code Camp 2012 Steve Stedman

  8. Pingback: » Unleashing Common Table Expressions Steve Stedman

  9. Pingback: » SQL Server Memory Hog Query Steve Stedman

  10. Pingback: » End of June Summary Steve Stedman

Leave a Reply

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

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=""> <strike> <strong>

Powered by sweet Captcha