Cross apply and outer apply in sql server

[@SKAV93]

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.

[@Csharp-video-tutorialsBlogspot]

+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 kzbin.infoplaylists?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. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info 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

[@sangeethks2011]

One of the most valuable 8 minutes in youtube.

[@robertbobm]

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!

[@88spaces]

Sometimes you wonder if you really understand a concept. Your video brings it home. Thank you.

[@S-we2gp]

Thanks for being the only guy to put a coherent explanation together.

[@naveenkumarmadari5883]

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!

[@HinesBrad]

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.

[@justinli19901027]

I love this guy as a generous human being who love to share with others! Thank you so much for the most excellent tutorials!

[@matthewbromilow3927]

Thanks even better than the Microsoft tutorial the explanation was really clear and its opened up a lot of practical possibilities too!

[@srcousar]

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.

[@howardtheduck24]

Microsoft should hire you to write their books. Good work, thanks

[@ravijethva1250]

before landing to this video, CROSS APPLY was Everest me! I did not know how simpler it was.. you made it simple! thank you..

[@VeritacitySolutions]

Agreeing with other commenters. Very clear and concise explaination. Now that I have watched this video the msdn discussion makes more sense. Thank you.

[@mipebs]

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 KZbin and found this excellent contribution. Thank You very much!!

[@krzysztofs8535]

Thank you for educating community. This tutorial is the best available on youtube. You are best teacher in the world.

[@fabianolmos737]

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

[@tr3251qw]

Thank a lot for this video ! Your explanation is the best !

[@BrokenLightPole]

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!

[@MikeWood-kp2tx]

Brilliant, so concise and you show each logical step. Thank you!

[@lorisean06]

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!

[@bnguyenp6]

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

[@kevinfry3952]

Thank you. I have watched many of these but this was the best explanation by far!

[@patriciaconstantinososa7298]

My new favourite KZbin channel, thank you Venkat for your generous effort to explain these concepts in a clear manner to everyone!

[@dennisdanield]

How simply he is explaining..Great Sir.Thank you very much.

[@sumx1972]

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.

[@saikiran-xo5we]

clearly explained with good examples. thanks sir.

[@ugochionwuliri5300]

venkat you're the best. These videos are so rich and well explained. Thank you for taking out time to do this.

[@saikiranp.r6966]

To the point explanation. Venkat you just made my day. Thank you and keep us teaching.

[@amirmir3244]

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.

[@RaviVanam99]

Thanks!!. I finally understood. You are awesome!

[@sjirjis7]

You always have the best content! Clear lecture and demo, every time!

[@fluxcap4630]

Amazing video! clear and concise explanation, with easy to understand examples. 10/10 brother

[@narendrac2260]

This is really quality material on cross/outer apply

[@sakalleydhruv]

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.

[@naodagere8210]

I am always thinking the time it took you to prepare such an amazing resource.Thank you so much. God bless you.

[@KedIsKeenSports]

Awesome explanation of this!! 👏🏾 👏🏾 Great job!

[@alfredmercer4081]

Thank you for this very clear explanation. I was able to really streamline some of my code with this.

[@suryanarayanbaliarsingh5363]

Brilliant... Once again Thank you Venkat Sir..Your explanations are outstanding.

[@escapetothesky]

Clear and concise .. good video, thank you

[@jackwillhoite6400]

Excellent explanation of an often misunderstood topic. Thank you.

[@vishwanath0401]

Wonderful explanation with clear and precise examples. Very helpful. Loved it Venkat.

[@trinamarie2107]

Thanks as always for a clear and succinct explanation! I learn so much from your tutorials - they are the best!

[@CBrown]

This video helped clarify APPLYs a lot. Thank you.

[@mattnielsen9812]

Thanks for the video, make understanding this function much easier.

[@ronakpatel4239]

How could you be so precise. It's amazing. Thanks

[@nayeersamsi808]

After 6 years of working ..finally i understood it ... Phew ..late but at least reach

[@tiagosilva856]

Good Job 👍

[@gizmo928]

This was the best explanation, thank you so much!

[@sohailkan17]

Thankyou for this amazing explaination

[@MrIrrepressible]

Great vid, easy to follow and understand.

[@rohithlobo635]

You're the best.. kudos KUDVenkat :) you make our lives so simple...:)

[@saifqawasmeh9664]

you my friend are genius, thank you for this tutorial

[@Theanatolievich]

The best sql videos ever.

[@sasyboy2]

Great explanation, thank you.

[@EisenSpitze]

thx for this Video ! A very simple but clear Video, which helps it easy to understand ! And thxfor speaking slowly ;)

[@nycolassilvestre6434]

Thank you for the explanation! I really appreciate it.

[@deepikakbify]

Thank you very much for these videos.

[@michaelhearmon9965]

Thank you very much, this is what I was looking for. Subscribbed

[@sonynavi]

Crisp and clear explanation

[@Shri-RAM-JaiBajrangBali]

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...

[@dineshs4560]

This video make my day as useful. Thanks a lot for the simple explanation. Keep it up Bro...

[@RizwanAhmedSurhio]

BRILLIANT !! Million Thanks

[@hemanttoday]

Great work.

[@pasito287]

very useful tutorials till now

[@TheAndozio]

THANKS FOR THE GREAT VIDEO.

[@bnguyenp6]

same here . This is a brilliant explanation

[@AngeloBommarito]

Your videos are excellent, and easy to understand. Thank you very much. You should get these on Khan Academy

[@kokosda]

Greate explanation, bro!

[@NaveedAmwani1]

wonderful explaination

[@stephane777_]

thank you kudvenkat, really helpful ! I am gonna subscribe :)

[@chitranjansoni2455]

excellent explanation...over the vedio on youtube.

[@alekseyr7394]

It's just perfect, thanks!

[@ananthasubramanian7355]

Thank you for a nice video

[@Chinnurockbells]

good example sir

[@hungrymynd5673]

Great tutorial. Thank you!

[@arkalahiri8749]

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?

[@sandeepbabusirisinagandla2504]

Good explanation...!

[@chesterchaz135]

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 ?

[@deepakbhagat811]

thank you this tutorial is very informative

[@pparturo2007]

Excellent explanation.

[@RAlvTorre]

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.

[@AshProgHelp]

thanks for this tutorial

[@romeror1945]

great video

[@rajenshah8032]

Excellent explanation...

[@7116matrix]

Awesome lesson, thanks!

[@dnadelson]

amazing as always.

[@epicwhat001]

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

[@sajadahanger9499]

Loved it!

[@julianatlas5172]

good info, thanks!

[@tam1586]

Great explanation! Thanks! :)

[@aartibhatia8415]

Hello Sir, u r my Guru. Please provide us tutorials for Optimisation. It's a request..

[@meettoraju]

Brilliant...

[@michaelmauter3670]

Nice video, thank you!

[@younesshaimi1450]

great job

[@tharif4me]

Nice Article...Thanxx....Bro

[@dasarivenkatachalapathi6311]

good explanation

[@luigizambetti18]

Hello Kudvenkat, just a question: all the videos in this playlist could be enough for preparing to 70-761 certification exam?

[@klevindoda8317]

Brilliant!

[@hishoegypt1980]

Thank you very much

[@behnamdehghan]

Very helpful, thanks! (y)