Recursive CTE in T-SQL explanation in as simple a way as possible
-
Hi CodeProject members, Greetings! After being a passive reader of CodeProject articles for so long a time, it feels great to be actively contributing something to this thriving and extremely helpful community. Recently, I decided to undertake the task of explaining some relatively complex concepts of T-SQL, SQL Server and MSBI, in an effort to give back something to the community I have been learning from for so long. My goal is to simplify the explanation and elucidation of the concepts as much as possible, at the expense of being annoyingly verbose if need be. ;P To this effect, I started with explanation of a recursive Common Table Expression in t-SQL. My article can be found at http://www.codeproject.com/Articles/1139746/Recursive-CTE. Now this is my first attempt at explaining something in writing. I need feedback-, how have I fared overall, suggestions for improvement, possible topics for later etc. Thus, I am sincerely hoping, active community members would help me out in this regard. I have tried explaining the recursive CTE concept to the best of my ability here. But of course, often one's best is still lacking in some respects. Please come forth with your comments and feedback. Could I have used a better example to explain the concept? Could I have used better formatting for the code snippets? Or the result-sets? How could I have ensured that this article is as helpful as possible to a person who is finding it difficult to grasp the recursive CTE concept? Looking forward to hearing from you.