SQL Server Multiple Recursive Member CTEs

Recursive CTEs are helpful for solving certain types of problems in SQL Server. But did you know that you can write CTEs with MULTIPLE recursive statements? Learn how in this week's episode.
Subscribe and turn on notifications to never miss a weekly video: www.youtube.co...
Related blog post with full example code goodness: bertwagner.com...
Itzik Ben-Gan's article on multiple recursive member CTEs: www.itprotoday...
Follow me on Twitter:
/ bertwagner

[@hindi-english1664]

great

[@sql3051]

Bert, Great information again. Really appreciate it.

[@ChrisBeardsley]

I ran into a hiccup with the recursion default setting while tinkering. It is limited to and errors out after 100, unless 'option (maxrecursion x) ' is specified in the query. Not a big deal, but others are sure to hit this as the tinker.

[@jaserogers997]

Just use an auxiliary numbers TVF to generate the ints and wrap in the CASE.

[@jaserogers997]

@@DataWithBert Thanks for the reply. It was an informative watch.

[@arunr8058]

Nice one.
While using multiple recursive CTE, its infinite recursive happened how to fix this infinite recursive.

[@RC-nn1ld]

Love it great vid

[@andersconner4174]

I realize I'm quite off topic but does anybody know of a good place to watch newly released tv shows online ?

[@carldamien1889]

@Anders Conner flixportal xD

[@andersconner4174]

@Carl Damien thanks, I went there and it seems to work :) I really appreciate it!!

[@carldamien1889]

@Anders Conner No problem :)

[@juliawenkmann8510]

You're great!

[@mudasir989]

Hi Brent - How long did it take you master SQL and what was your first job in SQL