Hello and welcome to the second part of our Recursive Queries in MS SQL Server course. In the previous part, you checked your current knowledge of T-SQL. Now, it's time for the real fun to begin.

We're going to teach you basic CTEs. This part may not present new possibilities in T-SQL, but you should still treat it as an introduction to more advanced topics. For now, it's important that you get the basics right.

As always, we'll start off by introducing the tables we're going to work with.