Click here to Skip to main content
14,768,146 members
Home » Discussions » Database
   

Database

 
AnswerRe: Use Conditions In Query [MySQL] Pin
Richard Deeming1-Nov-16 11:24
mveRichard Deeming1-Nov-16 11:24 
QuestionRe: Use Conditions In Query [MySQL] Pin
Django_Untaken1-Nov-16 20:54
MemberDjango_Untaken1-Nov-16 20:54 
AnswerRe: Use Conditions In Query [MySQL] Pin
Richard Deeming2-Nov-16 3:51
mveRichard Deeming2-Nov-16 3:51 
AnswerRe: Use Conditions In Query [MySQL] Pin
phil.o1-Nov-16 15:01
mvephil.o1-Nov-16 15:01 
GeneralRe: Use Conditions In Query [MySQL] Pin
Django_Untaken1-Nov-16 20:45
MemberDjango_Untaken1-Nov-16 20:45 
GeneralRe: Use Conditions In Query [MySQL] Pin
phil.o1-Nov-16 22:19
mvephil.o1-Nov-16 22:19 
QuestionExtending SSIS components Pin
Rahul_Biswas26-Oct-16 20:11
professionalRahul_Biswas26-Oct-16 20:11 
QuestionRecursive CTE in T-SQL Pin
Rahul_Biswas24-Oct-16 23:15
professionalRahul_Biswas24-Oct-16 23:15 
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. Poke tongue | ;-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.
AnswerRe: Recursive CTE in T-SQL Pin
Richard MacCutchan25-Oct-16 1:18
mveRichard MacCutchan25-Oct-16 1:18 
GeneralRe: Recursive CTE in T-SQL Pin
Rahul_Biswas25-Oct-16 1:44
professionalRahul_Biswas25-Oct-16 1:44 
GeneralRe: Recursive CTE in T-SQL Pin
Richard MacCutchan25-Oct-16 1:51
mveRichard MacCutchan25-Oct-16 1:51 
GeneralRe: Recursive CTE in T-SQL Pin
Rahul_Biswas25-Oct-16 1:58
professionalRahul_Biswas25-Oct-16 1:58 
GeneralRe: Recursive CTE in T-SQL Pin
Richard MacCutchan25-Oct-16 2:08
mveRichard MacCutchan25-Oct-16 2:08 
QuestionWhy SQL server maintenance plan Cannot rebuild clustered index offline? Pin
cornpoppy24-Oct-16 1:11
Membercornpoppy24-Oct-16 1:11 
AnswerRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
Eddy Vluggen25-Oct-16 1:37
professionalEddy Vluggen25-Oct-16 1:37 
GeneralRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
cornpoppy25-Oct-16 19:50
Membercornpoppy25-Oct-16 19:50 
GeneralRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
Eddy Vluggen25-Oct-16 23:17
professionalEddy Vluggen25-Oct-16 23:17 
AnswerRe: Why SQL server maintenance plan Cannot rebuild clustered index offline? Pin
Richard Deeming26-Oct-16 4:23
mveRichard Deeming26-Oct-16 4:23 
QuestionConfiguration from a parent variable "ServerName" did not occur because there was no parent variable collection or Edit the existing Package Configurations using C# Pin
indian14321-Oct-16 13:12
Memberindian14321-Oct-16 13:12 
QuestionVisual Studio Database Projects and General Use Pin
cjb11018-Oct-16 3:38
Membercjb11018-Oct-16 3:38 
AnswerRe: Visual Studio Database Projects and General Use Pin
Matt U.18-Oct-16 11:12
MemberMatt U.18-Oct-16 11:12 
GeneralRe: Visual Studio Database Projects and General Use Pin
cjb11019-Oct-16 21:56
Membercjb11019-Oct-16 21:56 
GeneralRe: Visual Studio Database Projects and General Use Pin
Matt U.20-Oct-16 6:01
MemberMatt U.20-Oct-16 6:01 
SuggestionIncrease the Execution time or Connection Time out property of SSIS package from C# code Pin
indian14312-Oct-16 14:40
Memberindian14312-Oct-16 14:40 
QuestionTo run a SSIS package outside of SQL server data tools you must install populate filecollection of integration services or higher Pin
indian14310-Oct-16 7:39
Memberindian14310-Oct-16 7:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.