SQL Recursive Join with CTE Part 2 | Quick Tips Ep60
Автор: Joey Blue
Загружено: 2021-03-10
Просмотров: 7563
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
