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
UA-cam NEWS UPDATES
/ sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
ua-cam.com/users/subscription_c...
SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com
LET'S CONNECT!
LinkedIn: / joeyblue
SQLTrainingOnline: www.sqltrainingonline.com

[@TheMisiekMisiek]

Really good. Well explained, I don't need the code, I need to learn how to do it on my own. ;) Do some more tutorials, please.

[@GladiusArmis]

Nice. I can use this. I wish I had the code, and didn't need to recreate it from UA-cam.

[@georgefuller34471]

do you have the code to create and load the tables or CSV's to upload?