SQL Recursive Join with CTE Part 2 | Quick Tips Ep60

In this video I show you how to execute a recursive join against an Accounting Chart of Account table to expose the hierarchy of accounts. 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 Recursive Join with CTE Part 2 | Quick Tips Episode #60 TABLE OF CONTENTS 0:00 - Intro 1:14 - Look at DimAccount Table 1:55 - Primary and Foreign Keys 3:53 - Account Hierarchy with Recursive Join in CTE (Common Table Expression) 10:04 - NULL Conversion Error 11:41 - Adding Levels and Pivoting Columns 17:29 - Changing the Anchor Record with Multiples 19:05 - Joining CTE back to DimAccount Table 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