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
- Introduction
- Prerequisites
- What is a Common Table Expression
- Simple CTE
- CTE – Subquery Re-use
- Recursive CTE
- Multiple CTE
- CTE Common Uses
- CTE for Math Geeks
- CTE Fact or Fiction – Debunking
Other SQL Server CTE Material, Posts, and Samples On This Site
CTE Hierarchy compared to the alternative
Calculating Factorials with a Recursive CTE
CTE – With An Insert Statement
Generating a Tree Path with a CTE
Multiple CTE’s in a single Query
CTE Presentations
SQL Saturday 166 in Olympia WA
SQL Saturday 172 in Portland Oregon
A Great Day at SQL Saturday 108 in Redmond.
Pingback: » Can we use CTEs use in SSRS? Steve Stedman
Pingback: » TSQL 2012 – OFFSET and FETCH Steve Stedman
Pingback: » Using a CTE to Split a String Into Rows Steve Stedman
Pingback: » Using a CTE in a Function to Split Up a Query String Steve Stedman
Pingback: » SQL Lunch UK Steve Stedman
Pingback: » Sessions for Code Camp in 2 weeks Steve Stedman
Pingback: » Home after Seattle (Redmond) Code Camp 2012 Steve Stedman
Pingback: » Unleashing Common Table Expressions Steve Stedman
Pingback: » SQL Server Memory Hog Query Steve Stedman