Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in MS SQL Server

Introduction
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive ctes
Summary

Instruction

Quite impressive, right? We'll now help you construct the query step-by-step, so you understand how it works.

Exercise

In the first step, we'll show information about the boss. This is the only person in the table that has a NULL SuperiorId. For that person, show the Id, FirstName, LastName, SuperiorId, and a final column called Path with N'Boss' inside.

Stuck? Here's a hint!

Remember that you can check whether a value is NULL using:

WHERE ColumnName IS NULL