June Blog Post Wrap-up

Recursive CTE Examples

Wed, 29 Jun 2022

Transcription of Video: One of the things I like play with is performance and pushing things to their limits. So what I want to do next is see how far can we push this sum of parts? Can we d Read more…

Steve Explains how to build a Recursive CTE

Tue, 28 Jun 2022

Transcription of Video: So here’s an example of building a recursive common table expression, I’m gonna start out with the with statement, we’re gonna call it department CTE. And we’re going to label the columns that we’re going to retur Read more…

Steve’s Introduction to Recursive Common Table Expressions

Mon, 27 Jun 2022

Transcription of Video: Now on to recursive common table expressions. This is my favorite part. And this is where it gets really fun is working with recursive CTE’s. Because with recursive CTE, we’re doing things that are really difficult t Read more…

Recursive CTE Terminology

Fri, 24 Jun 2022

Transcription of Video: Every recursive CTE needs an anchor query. And what an anchor query is, is it defines the start of the recursion. This is the part that cannot reference the CTE itself, it has to start with som Read more…