Recursive CTE uses

• Xedni

  SSCertifiable

  Points: 6951

  More actions

  May 5, 2012 at 4:13 pm

  #268383

  Hi SSC,

  I've been trying to wrap my head around recursive CTEs and the only example I can find is variants of the classic "who reports to whom" example[/url]. I understand the idea of the anchor portion and the recursive portion. I'd like to be able to add this technique to my repertoire, but I learn best by practicing these things, and the classic scenario seems a bit contrived for every day use. What sort of other clever examples do others have of using recursive CTEs?

  Thanks!

  Executive Junior Cowboy Developer, Esq.[/url]

• ChrisM@home

  SSC-Insane

  Points: 24260

  More actions

  May 6, 2012 at 2:46 am

  #1483864

  There are a few uses of rCTE's in this thread;

  http://www.sqlservercentral.com/Forums/FindPost1202081.aspx

  ---

  [font="Arial"]^{Low-hanging fruit picker and defender of the moggies}[/font]

  For better assistance in answering your questions, please read this[/url].

  ---

  Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

  Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]