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
youtube.com/user/sqltrainingonline

VISIT SQLTRAININGONLINE.COM FOR MORE VIDEO NEWS & TIPS
www.sqltrainingonline.com/

SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
youtube.com/subscription_center?add_user=sqltraini…

SUBSCRIBE TO OUR EMAIL LIST!
www.sqltrainingonline.com/

LET'S CONNECT!
LinkedIn: linkedin.com/in/joeyblue
SQLTrainingOnline: www.sqltrainingonline.com/