Recursive CTE in T-SQL
-
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 [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.
-
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 [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.
-
It is bad form to try and promote your article in the forums. You will get feedback when people read your article.
Sigh! I thought I have already been through all this with one person. :sigh: Look. I wanted to post my message only once. At one place. But when I get confronted with a message like 'Message Removed', what is a newbie like me supposed to think? That maybe this isn't the right place to post a message like this. This happened to me when I went to post the message elsewhere too. Therefore the repetition.
-
Sigh! I thought I have already been through all this with one person. :sigh: Look. I wanted to post my message only once. At one place. But when I get confronted with a message like 'Message Removed', what is a newbie like me supposed to think? That maybe this isn't the right place to post a message like this. This happened to me when I went to post the message elsewhere too. Therefore the repetition.
-
You are not a newbie, you have been a member over 7 years. Plenty of time to read the stickies at the top of each forum.
I am a newbie when it comes to posting an article here. I am a newbie when it comes to posting a message here. I am a newbie when it comes to confronting a message like 'Message Removed' once I make an edit to a message here. I might have joined CodeProject 7 years back. But I was not an active community member here.
-
I am a newbie when it comes to posting an article here. I am a newbie when it comes to posting a message here. I am a newbie when it comes to confronting a message like 'Message Removed' once I make an edit to a message here. I might have joined CodeProject 7 years back. But I was not an active community member here.