SQL Recursion with CTE Part 1 | Quick Tips Ep59

The very last explanation needs a deep level, but the rest is perfect!

Thank you for this very useful video!

You saved my day, thanks lot for taking time and explained in a very clear way 🙏👍

Extremely clear and helpful. Thank you!

Now I got it , thanks a lot

Can you do a video on DIFFERENCE please?

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 👍

How do you go the other way? I want to know who is at the apex of ward's leadership structure.

@Joey Blue just want to say: I appreciate Your work ;)
thx

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.

Absolutely stunning explanation. Thank you much!

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?)

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.

Pretty advanced stuff

you won everyone's heart when you said lets do one more excercise.

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?

Thanks for making this.

THANK YOU

LOVE IT

after watching so many videos on this topic, i finally understand it thanks to you!

The only video on the internet that helped me understand this concept clearly. Thanks a lot!

Your way of explaining is very very good! Too bad that are not all like you

HI, Great tutorial. Where can I get the db you're working with so I can practice myself?

The best recursive cte movie I've ever seen. I love your way of explaining

Best video on Recursive CTEs! Thanks a ton Joey!

Today I had a task to work with hierarchy in mssql and found your video . Thanks! It helped a lot :)

sucess

How do I get a copy of this code?

Very thorough and detailed explanation, thanks.

"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)

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?

Great video !