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 ua-cam.com/users/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. ua-cam.com/video/y780MwhY70s/v-deo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ua-cam.com/users/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.
Agreeing with other commenters. Very clear and concise explaination. Now that I have watched this video the msdn discussion makes more sense. 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 UA-cam and found this excellent contribution. Thank You very much!!
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!
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!
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
ua-cam.com/users/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.
ua-cam.com/video/y780MwhY70s/v-deo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ua-cam.com/users/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
One of the most valuable 8 minutes in youtube.
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!
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!
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!
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!
Thank you for educating community. This tutorial is the best available on youtube. You are best teacher in the world.
Microsoft should hire you to write their books. Good work, thanks
nicely explained with simple examples, clear & concise, thank you very much for sharing :)
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 UA-cam and found this excellent contribution. Thank You very much!!
Thank a lot for this video ! Your explanation is the best !
How simply he is explaining..Great Sir.Thank you very much.
Brilliant, so concise and you show each logical step. Thank you!
clearly explained with good examples. thanks sir.
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
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!
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!
This is really quality material on cross/outer apply
Thank you. I have watched many of these but this was the best explanation by far!
Awesome explanation of this!! 👏🏾 👏🏾 Great job!
My new favourite UA-cam channel, thank you Venkat for your generous effort to explain these concepts in a clear manner to everyone!
Clear and concise .. good video, thank you
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.
Thanks!!. I finally understood. You are awesome!
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...
Excellent explanation of an often misunderstood topic. Thank you.
You always have the best content! Clear lecture and demo, every time!
To the point explanation. Venkat you just made my day. Thank you and keep us teaching.
Amazing video! clear and concise explanation, with easy to understand examples. 10/10 brother
I am always thinking the time it took you to prepare such an amazing resource.Thank you so much. God bless you.
This video helped clarify APPLYs a lot. Thank you.
After 6 years of working ..finally i understood it ... Phew ..late but at least reach
The best sql videos ever.
Wonderful explanation with clear and precise examples. Very helpful. Loved it Venkat.
Brilliant... Once again Thank you Venkat Sir..Your explanations are outstanding.
venkat you're the best. These videos are so rich and well explained. Thank you for taking out time to do this.
Thank you for this very clear explanation. I was able to really streamline some of my code with this.
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.
BRILLIANT !! Million Thanks
How could you be so precise. It's amazing. Thanks
very useful tutorials till now
Great vid, easy to follow and understand.
Thankyou for this amazing explaination
Crisp and clear explanation
Good Job 👍
Thanks for the video, make understanding this function much easier.
Thanks as always for a clear and succinct explanation! I learn so much from your tutorials - they are the best!
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.
You're the best.. kudos KUDVenkat :) you make our lives so simple...:)
This was the best explanation, thank you so much!
you my friend are genius, thank you for this tutorial
same here . This is a brilliant explanation
Great explanation, thank you.
Thank you very much for these videos.
excellent explanation...over the vedio on youtube.
THANKS FOR THE GREAT VIDEO.
Thank you very much, this is what I was looking for. Subscribbed
Great work.
good example sir
Thank you for the explanation!
I really appreciate it.
Greate explanation, bro!
This video make my day as useful. Thanks a lot for the simple explanation. Keep it up Bro...
wonderful explaination
It's just perfect, thanks!
Good explanation...!
thx for this Video ! A very simple but clear Video, which helps it easy to understand !
And thxfor speaking slowly ;)
Excellent explanation.
Excellent explanation...
Thank you for a nice video
thanks for this tutorial
thank you this tutorial is very informative
Nice Article...Thanxx....Bro
Great explanation! Thanks! :)
Awesome lesson, thanks!
Great tutorial. Thank you!
amazing as always.
great video
thank you kudvenkat, really helpful ! I am gonna subscribe :)
Brilliant...
Your videos are excellent, and easy to understand. Thank you very much. You should get these on Khan Academy
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
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 ?
Nice video, thank you!
good info, thanks!
Loved it!
great job
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.
Very helpful, thanks! (y)
Thank you very much
nice explanation
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?
Brilliant!
Hello Sir, u r my Guru. Please provide us tutorials for Optimisation. It's a request..