SQL Recursion with CTE Part 1 | Quick Tips Ep59

In this video I show you how to execute a recursive CTE (Common Table Expression) against Employee table. I demonstrate recursion and walk you through the different parts of recursive join. The demonstration uses SQL Server and SQL Server Management Studio (SSMS). SQL Recursion with CTE Part 1 | Quick Tips Episode #59 TABLE OF CONTENTS 0:00 - Intro 0:20 - Regular CTE Example 1:15 - Recursive CTE Example - SQL 4:06 - Recursive CTE Results Walkthrough - Excel 7:48 - Recursive CTE with Hierarchy - Introduction 11:11 - Recursive CTE with Hierarchy - SQL 18:04 - Recursive CTE with Hierarchy Results Walkthrough - Excel 23:38 - Adding Levels to the Hierarchy 25:07 - Changing Anchor Record 25:48 - Adding Comma List of All Manager to Employee 31:42 - Pivoting Hierarchy for Reporting YOUTUBE NEWS UPDATES    / sqltrainingonline   VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_c... SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! LinkedIn:   / joeyblue   SQLTrainingOnline: http://www.sqltrainingonline.com