Simple Recursion in SQL

[@piiner4815]

12:00 was the key moment, thanks doug

[@ethansanabria2892]

You're very good at explaining, definitely an excellent teacher! Thank you.

[@krehkop11]

Finally, someone I can understand. Great job!

[@ajlestrad]

Thank you so much, this is exactly what i needed for my job. Infinitas gracias from Mexico

[@nelseify]

I finally get this concept thanks to this video. Many thanks

[@PieterBuys]

Here's the link to the code in his blog douglaskline.blogspot.com/2016/06/simple-recursion-in-sql-with-common.html

[@adreamer9999]

Great explanation and sql code walk-through. Thanks Doug!

[@matthewtuell9335]

I can actually visualize how recursion works now. Thanks!

[@tommyh4137]

I appreciate the video. You did a good job of explaining everything. Maybe next time go through how it works within the code of the recursion kind of like debugging mode so we can see how the process works within the sql code.

[@vesperannstas]

This is exactly what I needed. Thank you!

[@chand0503]

Very helpful!! Thank you so much

[@НиколайЩекин-и9ъ]

Thank you for the video, it added a lof of clarity=)

[@DidierVerscheure]

Thanks for the very good explanation. I really helped me saving a lot of hours.

[@Dawa202]

Thanks Doug this was a great explanation

[@yashkaliapiano]

thanks you did a good job explaining the key concept

[@bojandanon2037]

Superb video, thanks :)

[@mads2k5]

My brain hurts from grasping this concept. Your video is very helpful though.

[@pereteatcuadelina5131]

Thank you for a nice video and good explanation!

[@MikelNaUsaCom]

Good example. No link to code in the description though. I can find examples using google, thanks!

[@gigidargostino]

Hello,
how to get the Depth 2 of each employee?For example i have EmpID = 13 (Johnson) i want to get BossLastName = Fuller. The same query have to work with each employee, for example 11 (Kline) or maybee some employee in Depth level 100 should return the 2nd level Manager

[@Rauly4557]

Fantastic! Thank you, I knew it must be an easier way to do this (it always is).

[@Kangsemo]

very good explaned and helped me alot, thank you

[@ChaimMosheStern]

wow simple & to the point

[@neerajbhanot7511]

thanks for the tutorial. It was really helpful

[@zanarkandmusic]

Great explanation. Thanks =)

[@yino89]

Hi Doug,
Nice tutorial video you had there. Where could we find the link to the sample of the code.
with regards,
chunchiat

[@royalearning6786]

hey doug is it possible that when a parent have two references it gets some cash and then if that two persons have more 2,2 references then parent and granparent gets also and so on

[@djordjemilenkovic96]

How can be done recursion delete for this example?

[@michelli88]

wow, very good explanation! Thankyou

[@aravindm5848]

good explanation!

[@claudiocerruti4036]

Thanks a lot for this video. It helped me a lot. Where can I find the code? Thanks in advance

[@tafarir9119]

douglaskline.blogspot.com/search?q=Recursion&m=1

[@sf11691]

Great explanation, thanks!

[@mianameerhamza2421]

Hey Goug i want to ask something as we move from high to downward direction is it possible to move from downward to upaward direction

[@rafaelcasco655]

How u create this recursive in sql code
Like
Create table employee
I have to create 2 tables employees and boss or only employees

[@paulpelludat6194]

really nice vid. What happens if ReportsTo has an entry? How can I edit the queries to make it nethertheless possible to execute?

[@VitalyBelenky]

Thanks Doug!

[@arunavaghosh749]

Great explanation. But one query. What if we need to get the hierarchy for a specific employee ?

[@DatabasebyDoug]

You can limit results to just the employee of interest vin the WHERE clause

[@arunavaghosh749]

@@DatabasebyDoug Yes resolved that based on your explanation. Your explanation really helped.

[@uppuharichandan961]

Thanks alot it's wonderful video

[@kungu123]

Great explanation - do you have a link for where i can find this code?

[@leonying7107]

Maybe I'm being a bit slow, but the bit I'd still like to understand is why Fuller is returned to the result set when his 'ReportsTo' is null and the same field is linking the recursion via an inner join.

[@leonying7107]

don't worry, I've just seen it.... Level one is returned in the first union....

[@surajlal5800]

Hi, just wondering can i get this code please

[@blackcrowartistry]

Great explanation!

[@aRtUr0c]

thanks!

[@firdausyangga1328]

Hi, Doug nice explanation! But, can i get the full code?

[@hmmm1435]

No link to the code?

[@arpitbhatnagar2228]

Thank you!

[@josefhuber2401]

great

[@tafarir9119]

Link to code: douglaskline.blogspot.com/search?q=Recursion&m=1

[@MatthiasBloch]

FIRST!

[@muhammadarqam1741]

single video with multiple ads. fed up. disgusting