I have to admit I am one of the millions of people who watch or read an article and never leave a comment even when the article is good. However in this case I have to make an exception since the explanation on how to use CROSS APPLY in this video is just brilliant!!. I have heard may people trying to explain and seen it used more frequently now and I kept thinking that an INNER JOIN could be used instead of a CROSS APPLY. This video has cleared up any misunderstanding and I want to say special thanks to kudvenkat for taking the time to explain so well.
+SKAV93 Thank you so much for the feedback. Means a lot. I am very glad you found the videos useful and cleared your misunderstanding. I have organised all the Dot Net & SQL Server video tutorials in to playlists, which could be useful to you ruclips.net/user/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos and slides for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ruclips.net/video/y780MwhY70s/видео.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ruclips.net/user/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Best Regards Venkat
I've been developing in SQL for 5 years now. I've come across outer apply and cross apply in the past, but never truly knew why they were used instead of inner join or left join. I can't believe how simple it was, thank you so much. Please keep up the good work, your tutorials have helped me a lot. I hope you consider doing some mobile development and smart device development tutorials in the near future!
Hi Venkat, I've been following your channel for almost 9 years now. Both C# , TSQL nd recently SQL performance. I must admit your courses are game change in my career. Keep up the good work. A big thank you for your service. God bless you!
I often go on a wild goose chase looking for something that simply and clearly explains concepts This video is exceptional and feel like I am viewing an excellent series. Thank you.
Today, for the first time, I came across code in a stored procedure that used outer apply and I had no idea why it was used. So, like everyone else, I googled outer apply and read articles attempting to explain how to use it. No Good. I simply did not understand. But this simple, clear, easy to understand video brought me up to speed on the outer apply and the cross apply. It's so good to understand and come out of the dark about something. Thank you.
I am just sitting since hours to understand the original Microsoft course 461 (video and book) regarding this topic - without any progress ...then I searched on RUclips and found this excellent contribution. Thank You very much!!
Agreeing with other commenters. Very clear and concise explaination. Now that I have watched this video the msdn discussion makes more sense. Thank you.
great video, good explanation, reading articles and trying to find out what CROSS/OUTER APPLY do and why they are needed did not help but you video helped me a lot!
Thank you for such a clear and concise explanation. I had tried reading various forums on this topic and it wasn't making sense. This explanation is perfect!
Hi Venkat, thanks a millions time for posting these video, I'm sending these video to all of my friend. I been searching for video that explain clearly and to the point. Yours are the only one do that. Thanks again
Excellent explanation. I like the fact that you demonstrated APPLY by first relating to our prior knowledge of JOINs. Choice of example makes great sense. Tx Kudvenkat.
YOU CAN LEARN FROM ANYWHERE BUT TRUST ME IF YOU WANT TO LEARN IN A VERY EASIEST WAY PLEASE LEARN FROM KUDVENKAT, YOU CAN CRACK ANY SQL INTERVIEW AFTER LEARNING FROM THESE VIDEOS... I HAVE CRACKED AND AGAIN AND AGAIN I AM LEARNING FROM HIS VIDEOS... THERE IS NO WORD, HOW TO SAY THANKS OR ANY MOST POPULAR WORD..KUDVENKAT SIR YOU ARE BEST SIR WHO TEACHES WELL WITH CRISP VOICE.. ONE WORD YOU ARE THE BEST OF BEST GURU...
Venkat, really great explanation! I must admit, you have really taken a complex concept and broken it down well for anyone to comprehend. I would like you to add on to this with an example of pivoting (multiple columns) from a table based on a value in a certain column. Don't forget to link that video in here if you do.
Ok. I think outer apply is equivalent to left inner join based on the results not left outer join. Great video but nobody noticed that, Left outer join will return non matching rows from left only but outer apply returned matching rows and non matching rows from the left
Hello Venkat, thank you for the tuts! Would you please help me find the SQL scripts? I cannot find them anywhere on your blog. I have been following this series and would like to work through the tables as I progress through. thanks in advance.
I have to admit I am one of the millions of people who watch or read an article and never leave a comment even when the article is good. However in this case I have to make an exception since the explanation on how to use CROSS APPLY in this video is just brilliant!!.
I have heard may people trying to explain and seen it used more frequently now and I kept thinking that an INNER JOIN could be used instead of a CROSS APPLY.
This video has cleared up any misunderstanding and I want to say special thanks to kudvenkat for taking the time to explain so well.
+SKAV93 Thank you so much for the feedback. Means a lot. I am very glad you found the videos useful and cleared your misunderstanding.
I have organised all the Dot Net & SQL Server video tutorials in to playlists, which could be useful to you
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos and slides for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ruclips.net/video/y780MwhY70s/видео.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ruclips.net/user/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Best Regards
Venkat
I've been developing in SQL for 5 years now. I've come across outer apply and cross apply in the past, but never truly knew why they were used instead of inner join or left join. I can't believe how simple it was, thank you so much. Please keep up the good work, your tutorials have helped me a lot. I hope you consider doing some mobile development and smart device development tutorials in the near future!
One of the most valuable 8 minutes in youtube.
Sometimes you wonder if you really understand a concept. Your video brings it home. Thank you.
Thanks for being the only guy to put a coherent explanation together.
Hi Venkat, I've been following your channel for almost 9 years now. Both C# , TSQL nd recently SQL performance. I must admit your courses are game change in my career. Keep up the good work. A big thank you for your service. God bless you!
Microsoft should hire you to write their books. Good work, thanks
I often go on a wild goose chase looking for something that simply and clearly explains concepts This video is exceptional and feel like I am viewing an excellent series. Thank you.
Today, for the first time, I came across code in a stored procedure that used outer apply and I had no idea why it was used. So, like everyone else, I googled outer apply and read articles attempting to explain how to use it. No Good. I simply did not understand. But this simple, clear, easy to understand video brought me up to speed on the outer apply and the cross apply. It's so good to understand and come out of the dark about something. Thank you.
before landing to this video, CROSS APPLY was Everest me! I did not know how simpler it was.. you made it simple! thank you..
I love this guy as a generous human being who love to share with others! Thank you so much for the most excellent tutorials!
Thank a lot for this video ! Your explanation is the best !
I am just sitting since hours to understand the original Microsoft course 461 (video and book) regarding this topic - without any progress ...then I searched on RUclips and found this excellent contribution. Thank You very much!!
After 6 years of working ..finally i understood it ... Phew ..late but at least reach
Agreeing with other commenters. Very clear and concise explaination. Now that I have watched this video the msdn discussion makes more sense. Thank you.
Thanks even better than the Microsoft tutorial the explanation was really clear and its opened up a lot of practical possibilities too!
How simply he is explaining..Great Sir.Thank you very much.
This is really quality material on cross/outer apply
Thank you for educating community. This tutorial is the best available on youtube. You are best teacher in the world.
Sir, I must be grateful with you for this tutorials, right now I'm studying for the 70-461 exam and this have been of great help for me
Thanks!!. I finally understood. You are awesome!
Brilliant, so concise and you show each logical step. Thank you!
great video, good explanation, reading articles and trying to find out what CROSS/OUTER APPLY do and why they are needed did not help but you video helped me a lot!
Awesome explanation of this!! 👏🏾 👏🏾 Great job!
Thank you for such a clear and concise explanation. I had tried reading various forums on this topic and it wasn't making sense. This explanation is perfect!
clearly explained with good examples. thanks sir.
Clear and concise .. good video, thank you
Amazing video! clear and concise explanation, with easy to understand examples. 10/10 brother
Hi Venkat, thanks a millions time for posting these video, I'm sending these video to all of my friend. I been searching for video that explain clearly and to the point. Yours are the only one do that. Thanks again
My new favourite RUclips channel, thank you Venkat for your generous effort to explain these concepts in a clear manner to everyone!
Excellent explanation of an often misunderstood topic. Thank you.
Thank you. I have watched many of these but this was the best explanation by far!
Excellent explanation. I like the fact that you demonstrated APPLY by first relating to our prior knowledge of JOINs. Choice of example makes great sense. Tx Kudvenkat.
Thankyou for this amazing explaination
Wonderful explanation with clear and precise examples. Very helpful. Loved it Venkat.
I am always thinking the time it took you to prepare such an amazing resource.Thank you so much. God bless you.
To the point explanation. Venkat you just made my day. Thank you and keep us teaching.
This video helped clarify APPLYs a lot. Thank you.
You always have the best content! Clear lecture and demo, every time!
Crisp and clear explanation
Good Job 👍
Brilliant... Once again Thank you Venkat Sir..Your explanations are outstanding.
very useful tutorials till now
YOU CAN LEARN FROM ANYWHERE BUT TRUST ME IF YOU WANT TO LEARN IN A VERY EASIEST WAY PLEASE LEARN FROM KUDVENKAT, YOU CAN CRACK ANY SQL INTERVIEW AFTER LEARNING FROM THESE VIDEOS... I HAVE CRACKED AND AGAIN AND AGAIN I AM LEARNING FROM HIS VIDEOS... THERE IS NO WORD, HOW TO SAY THANKS OR ANY MOST POPULAR WORD..KUDVENKAT SIR YOU ARE BEST SIR WHO TEACHES WELL WITH CRISP VOICE.. ONE WORD YOU ARE THE BEST OF BEST GURU...
Exceptionally explained, your way of breaking it down was fantastic!!!! I am so going to follow all your videos and blogs. Thank you and God bless.
venkat you're the best. These videos are so rich and well explained. Thank you for taking out time to do this.
How could you be so precise. It's amazing. Thanks
Thank you for this very clear explanation. I was able to really streamline some of my code with this.
The best sql videos ever.
Thanks for the video, make understanding this function much easier.
BRILLIANT !! Million Thanks
Great explanation, thank you.
Venkat, really great explanation! I must admit, you have really taken a complex concept and broken it down well for anyone to comprehend. I would like you to add on to this with an example of pivoting (multiple columns) from a table based on a value in a certain column. Don't forget to link that video in here if you do.
THANKS FOR THE GREAT VIDEO.
Thanks as always for a clear and succinct explanation! I learn so much from your tutorials - they are the best!
same here . This is a brilliant explanation
you my friend are genius, thank you for this tutorial
You're the best.. kudos KUDVenkat :) you make our lives so simple...:)
Thank you very much for these videos.
Great vid, easy to follow and understand.
Greate explanation, bro!
Great work.
Thank you very much, this is what I was looking for. Subscribbed
This was the best explanation, thank you so much!
Thank you for the explanation!
I really appreciate it.
good example sir
excellent explanation...over the vedio on youtube.
Good explanation...!
It's just perfect, thanks!
Thank you for a nice video
Excellent explanation.
thx for this Video ! A very simple but clear Video, which helps it easy to understand !
And thxfor speaking slowly ;)
Excellent explanation...
thank you this tutorial is very informative
wonderful explaination
This video make my day as useful. Thanks a lot for the simple explanation. Keep it up Bro...
Your videos are excellent, and easy to understand. Thank you very much. You should get these on Khan Academy
Brilliant...
thanks for this tutorial
great video
Great tutorial. Thank you!
Awesome lesson, thanks!
Loved it!
good info, thanks!
Ok. I think outer apply is equivalent to left inner join based on the results not left outer join. Great video but nobody noticed that, Left outer join will return non matching rows from left only but outer apply returned matching rows and non matching rows from the left
Thank you very much
Nice video, thank you!
Great explanation! Thanks! :)
thank you kudvenkat, really helpful ! I am gonna subscribe :)
Nice Article...Thanxx....Bro
amazing as always.
In video 31 you mentioned that inline table valued function can be used in a join with an example. Why did that work and not this ?
This is the best content i have found till date...excellent work sir....where can i find the scripts to create the tables you use for demonstration?
great job
Brilliant!
Hello Sir, u r my Guru. Please provide us tutorials for Optimisation. It's a request..
Very helpful, thanks! (y)
Thanks!
Hello Venkat, thank you for the tuts! Would you please help me find the SQL scripts? I cannot find them anywhere on your blog. I have been following this series and would like to work through the tables as I progress through. thanks in advance.
nice explanation