This lesson introduces you to recursive common table expression. We go over a very simple example so you can get the basics down, and really understand how the anchor query, union, recursive member, and invocation work together to help you navigate hierarchical queries. After learn the fundamentals, you'll be ready to write queries for bill of materials (BOM) or org tables.
Get the full course. Here is a coupon! https://www.udemy.com/stored-procedures-unpacked-learn-to... Based on my popular course Stored Procedures Unpacked: Learn to Code T-SQL Stored Procs. Learn to develop, code, & implement stored procedures, transactions, & cursors, in your SQL Server database using T-SQL.