Thank you so much! 20+ years developer here in full stack (VB, C#, .NET), first time I actually understood the concept of CTE's and you helped me solve a very tricky problem I had, locating a mapping heirarchy 👍
Wow, thank you! This is an excellent explanation. I really prefer to understand what’s happening rather than just copying syntax, so this is much appreciated!
"sorry if I took so much time?" not everyone gets it in 2min video. Why does everyone think it is easy(they keep skipping many of the steps you explained, in their videos. ALL OF THAT HAPPENS AND ONLY THEN WE GET OUTPUT)? That excel sheet, iteration rows.. awesome. Thanks. You remind me of an underrated teacher who taught me C language. What you did to recursion, he did to pointers. tbh, I wondered whether this video would work before watching, by looking at those views and length of this video(actually, I spent more time than this video's length in figuring this recursion on my own, then watched 2 or 3 videos which didn't help and then landed here)
Hi Joey, Thank you for making such easy to understand videos. Could you please make one video on recursive CTE to handle the case when employeeID and ManagerID are same?
Thanx, really helped a lot! I thought I was going stupid, before this video. Btw. perhaps you should have concatenated the names instead of id first, that would have been simpler to wrap ones head around. But it was really well explained.
Thanks for explanation. I have one question. What if the count of level is dynamic? Hierarchy in companies I not constans. I think about last part of the video.
Hey Joey Blue...can you share the script to the heirarchy database...so we as students can try the recursive CTE ourselves? (Or is it one of the Adventureworks databases?)
Awesome video - I used the basic structure from the emp table to recurse through a table of about 250k rows. Running the recursion crashed my computer. I think it got overwhelmed having to join the 250k row table over an over again. Do you have any suggestions?
At 35:52 when I add the CAST function to the CTE Anchor, I get this error: Types don't match between the anchor and the recursive part in column "catlvl2" of recursive query "cat". edit: I figured it out. Just an FYI for anyone else: the type and character length need to match. EXACTLY. After some digging, I noticed that my engineers set the column length to MAX, so when following this example in the video, instead of putting "cast (columnname (50))" I had to put "cast (columnname (MAX))"
![[Gegagedigedagedago] NEW Help Gegagedigedagedago Nugget escape from Nikocado Avocado Challenge](http://i.ytimg.com/vi/hJWnwRC2Fz8/mqdefault.jpg)
The only video on the internet that helped me understand this concept clearly. Thanks a lot!
Took the words right from my mouth XD
Thank you so much! 20+ years developer here in full stack (VB, C#, .NET), first time I actually understood the concept of CTE's and you helped me solve a very tricky problem I had, locating a mapping heirarchy 👍
Wow, thank you! This is an excellent explanation. I really prefer to understand what’s happening rather than just copying syntax, so this is much appreciated!
you won everyone's heart when you said lets do one more excercise.
You saved my day, thanks lot for taking time and explained in a very clear way 🙏👍
Best video on Recursive CTEs! Thanks a ton Joey!
Extremely clear and helpful. Thank you!
Today I had a task to work with hierarchy in mssql and found your video . Thanks! It helped a lot :)
after watching so many videos on this topic, i finally understand it thanks to you!
"sorry if I took so much time?" not everyone gets it in 2min video. Why does everyone think it is easy(they keep skipping many of the steps you explained, in their videos. ALL OF THAT HAPPENS AND ONLY THEN WE GET OUTPUT)? That excel sheet, iteration rows.. awesome. Thanks. You remind me of an underrated teacher who taught me C language. What you did to recursion, he did to pointers. tbh, I wondered whether this video would work before watching, by looking at those views and length of this video(actually, I spent more time than this video's length in figuring this recursion on my own, then watched 2 or 3 videos which didn't help and then landed here)
Thank you for this very useful video!
Absolutely stunning explanation. Thank you much!
Very thorough and detailed explanation, thanks.
Hi Joey,
Thank you for making such easy to understand videos.
Could you please make one video on recursive CTE to handle the case when employeeID and ManagerID are same?
Your way of explaining is very very good! Too bad that are not all like you
The very last explanation needs a deep level, but the rest is perfect!
@Joey Blue just want to say: I appreciate Your work ;)
thx
Pretty advanced stuff
Thanks for making this.
Now I got it , thanks a lot
Thanx, really helped a lot! I thought I was going stupid, before this video. Btw. perhaps you should have concatenated the names instead of id first, that would have been simpler to wrap ones head around. But it was really well explained.
HI, Great tutorial. Where can I get the db you're working with so I can practice myself?
Thanks for explanation. I have one question. What if the count of level is dynamic? Hierarchy in companies I not constans. I think about last part of the video.
Thank you ❤❤
Thank you!
Hey Joey Blue...can you share the script to the heirarchy database...so we as students can try the recursive CTE ourselves? (Or is it one of the Adventureworks databases?)
How do you go the other way? I want to know who is at the apex of ward's leadership structure.
Can we start at a low spot whre something is NULL in the hierarchy and work up util we get a vaule up the hierarchy?
Great video !
LOVE IT
Can you do a video on DIFFERENCE please?
THANK YOU
Awesome video - I used the basic structure from the emp table to recurse through a table of about 250k rows. Running the recursion crashed my computer. I think it got overwhelmed having to join the 250k row table over an over again. Do you have any suggestions?
At 35:52 when I add the CAST function to the CTE Anchor, I get this error:
Types don't match between the anchor and the recursive part in column "catlvl2" of recursive query "cat".
edit: I figured it out. Just an FYI for anyone else: the type and character length need to match. EXACTLY. After some digging, I noticed that my engineers set the column length to MAX, so when following this example in the video, instead of putting "cast (columnname (50))" I had to put "cast (columnname (MAX))"
How do I get a copy of this code?
sucess