Common Table Expressions - Advanced

Speaker(s)Steve Stedman 

Duration: 60 minutes

Track: Application & Database Development

You have been introduced to Common Table Expression, you understand the WITH syntax, but you want to know more. Learn how to recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE and DELETE data from CTEs. Some of the common use cases for CTEs will be covered including finding holes in patterns, finding and removing duplicate data, string parsing, and more.  See how CTEs compare to SQL Server 2012 offset and fetch paging techniques. Get an in depth understanding of the performance behind a common table expression. Understand when the CTE is the right solution, and the wrong solution to use. Finally we will take a look at some classic recursive algorithms and how they can be implemented with CTEs. Take away several CTE samples that you can use to extend your TSQL query abilities.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.