This is the second video I've watched of yours. Great work! I feel like these videos are explaining concepts to me like I am 5 and that is EXACTLY what I need. Thanks for all your hard work!
You're doing a lot of stuff without giving any explanation of why you're doing it that way, or what the WITH statement actually means. People watching this video will learn how to memorize this specific example, but not learn the concepts.
Good job, everything I am looking at are WAY to complex. I am just starting with cte's and this was perfect! Thanks man! This makes sense now after watching your video. I don't even know why Microsoft has examples. . . they are always all over the place and usually contain way to much data.
Hi Joey, in 4:27 how did we figure out the inner join "on cteEmployee.manager=e.employee_number without referring to an ERD where you can easily see the common connections between tables? Thank you in advance.
Hi Nadia, Based on experience, I could tell that the manager column stored the employee number of the manager. It is common to have this relationship and to do a self-join. Sometimes you will have an actual foreign key and primary key relationship that tells you the two columns are related. Many times, you have to guess and then check to make sure the results make sense.
This is the second video I've watched of yours. Great work! I feel like these videos are explaining concepts to me like I am 5 and that is EXACTLY what I need. Thanks for all your hard work!
You're doing a lot of stuff without giving any explanation of why you're doing it that way, or what the WITH statement actually means. People watching this video will learn how to memorize this specific example, but not learn the concepts.
Exactly, I got confused starting at 4:50
Hi. When would you use a sub-query versus a with statement? Thank you.
Excellent free video! Very easy to follow can't wait to see your other videos! :-) I am a SQL developer and SSIS, SSRS along with BI development.
Thanks for explaining that. Could you clarify how is that different from a view? Is that the same?
Thats what I want to know
I believe a view is just a saved query with a name that you can reference
Very helpful.. Now i can write my own CTE with out help..!!
Great explanation, exactly what I needed to know, I decided to use a subquery instead of the WITH statement, subquery looked easier and nicer to me
Good job, everything I am looking at are WAY to complex. I am just starting with cte's and this was perfect! Thanks man! This makes sense now after watching your video. I don't even know why Microsoft has examples. . . they are always all over the place and usually contain way to much data.
Wow. It is a good explanation. Cristal clear
You're welcome. I'm glad it helped.
Joey Blue Merci beaucoup :)
I’m a bit confused on this one. Why even use WITH when you can just put the column names after the select clause?
Perfect explanation!!
Thanks a lot :)
Thank you very much!!!
Hi Joey, in 4:27 how did we figure out the inner join "on cteEmployee.manager=e.employee_number without referring to an ERD where you can easily see the common connections between tables? Thank you in advance.
Hi Nadia,
Based on experience, I could tell that the manager column stored the employee number of the manager. It is common to have this relationship and to do a self-join. Sometimes you will have an actual foreign key and primary key relationship that tells you the two columns are related. Many times, you have to guess and then check to make sure the results make sense.
Thank u, very helpful content.
Thank for Sharing. A very good explanation.
Thank you
Like from student Brasil.
Nice video, thanks for posting this.
Thanks joe
Thanks for sharing, I found it helpful.
Thanks a lot
Is this a Ms SQL server example ?
great
thanks man you saved my life :)
this code very nice thaks
i've been using nested queries for ages. I've been living a lie
thanks Joey
be mine!
Way too fast.
Thanks a lot!