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 *

*

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>

Powered by sweet Captcha

Newsletter Signup

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

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: