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-tutorialsBlogspot8 жыл бұрын
+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
@sangeethks20118 жыл бұрын
One of the most valuable 8 minutes in youtube.
@robertbobm9 жыл бұрын
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!
@88spaces3 жыл бұрын
Sometimes you wonder if you really understand a concept. Your video brings it home. Thank you.
@S-we2gp7 ай бұрын
Thanks for being the only guy to put a coherent explanation together.
@naveenkumarmadari58832 жыл бұрын
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!
@HinesBrad8 жыл бұрын
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.
@justinli199010278 жыл бұрын
I love this guy as a generous human being who love to share with others! Thank you so much for the most excellent tutorials!
@matthewbromilow39278 жыл бұрын
Thanks even better than the Microsoft tutorial the explanation was really clear and its opened up a lot of practical possibilities too!
@srcousar7 жыл бұрын
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.
@howardtheduck247 жыл бұрын
Microsoft should hire you to write their books. Good work, thanks
@ravijethva12505 жыл бұрын
before landing to this video, CROSS APPLY was Everest me! I did not know how simpler it was.. you made it simple! thank you..
@VeritacitySolutions8 жыл бұрын
Agreeing with other commenters. Very clear and concise explaination. Now that I have watched this video the msdn discussion makes more sense. Thank you.
@mipebs8 жыл бұрын
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!!
@krzysztofs85357 жыл бұрын
Thank you for educating community. This tutorial is the best available on youtube. You are best teacher in the world.
@fabianolmos7379 жыл бұрын
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
@tr3251qw3 жыл бұрын
Thank a lot for this video ! Your explanation is the best !
@BrokenLightPole4 жыл бұрын
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-kp2tx8 жыл бұрын
Brilliant, so concise and you show each logical step. Thank you!
@lorisean063 жыл бұрын
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!
@bnguyenp68 жыл бұрын
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
@kevinfry39527 жыл бұрын
Thank you. I have watched many of these but this was the best explanation by far!
@patriciaconstantinososa72988 жыл бұрын
My new favourite KZbin channel, thank you Venkat for your generous effort to explain these concepts in a clear manner to everyone!
@dennisdanield6 жыл бұрын
How simply he is explaining..Great Sir.Thank you very much.
@sumx19726 жыл бұрын
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-xo5we8 жыл бұрын
clearly explained with good examples. thanks sir.
@ugochionwuliri53007 жыл бұрын
venkat you're the best. These videos are so rich and well explained. Thank you for taking out time to do this.
@saikiranp.r69665 жыл бұрын
To the point explanation. Venkat you just made my day. Thank you and keep us teaching.
@amirmir32448 жыл бұрын
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.
@RaviVanam996 ай бұрын
Thanks!!. I finally understood. You are awesome!
@sjirjis76 жыл бұрын
You always have the best content! Clear lecture and demo, every time!
@fluxcap46302 жыл бұрын
Amazing video! clear and concise explanation, with easy to understand examples. 10/10 brother
@narendrac22603 жыл бұрын
This is really quality material on cross/outer apply
@sakalleydhruv8 жыл бұрын
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.
@naodagere82104 жыл бұрын
I am always thinking the time it took you to prepare such an amazing resource.Thank you so much. God bless you.
@KedIsKeenSports11 ай бұрын
Awesome explanation of this!! 👏🏾 👏🏾 Great job!
@alfredmercer40815 жыл бұрын
Thank you for this very clear explanation. I was able to really streamline some of my code with this.
@suryanarayanbaliarsingh53636 жыл бұрын
Brilliant... Once again Thank you Venkat Sir..Your explanations are outstanding.
@escapetothesky2 жыл бұрын
Clear and concise .. good video, thank you
@jackwillhoite64007 жыл бұрын
Excellent explanation of an often misunderstood topic. Thank you.
@vishwanath04014 жыл бұрын
Wonderful explanation with clear and precise examples. Very helpful. Loved it Venkat.
@trinamarie21078 жыл бұрын
Thanks as always for a clear and succinct explanation! I learn so much from your tutorials - they are the best!
@CBrown6 жыл бұрын
This video helped clarify APPLYs a lot. Thank you.
@mattnielsen98127 жыл бұрын
Thanks for the video, make understanding this function much easier.
@ronakpatel42397 жыл бұрын
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
@tiagosilva8563 жыл бұрын
Good Job 👍
@gizmo9285 жыл бұрын
This was the best explanation, thank you so much!
@sohailkan172 ай бұрын
Thankyou for this amazing explaination
@MrIrrepressible6 жыл бұрын
Great vid, easy to follow and understand.
@rohithlobo6355 жыл бұрын
You're the best.. kudos KUDVenkat :) you make our lives so simple...:)
@saifqawasmeh96646 жыл бұрын
you my friend are genius, thank you for this tutorial
@Theanatolievich8 жыл бұрын
The best sql videos ever.
@sasyboy22 жыл бұрын
Great explanation, thank you.
@EisenSpitze8 жыл бұрын
thx for this Video ! A very simple but clear Video, which helps it easy to understand ! And thxfor speaking slowly ;)
@nycolassilvestre64346 жыл бұрын
Thank you for the explanation! I really appreciate it.
@deepikakbify8 жыл бұрын
Thank you very much for these videos.
@michaelhearmon99655 жыл бұрын
Thank you very much, this is what I was looking for. Subscribbed
@sonynavi4 жыл бұрын
Crisp and clear explanation
@Shri-RAM-JaiBajrangBali10 ай бұрын
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...
@dineshs45606 жыл бұрын
This video make my day as useful. Thanks a lot for the simple explanation. Keep it up Bro...
@RizwanAhmedSurhio6 жыл бұрын
BRILLIANT !! Million Thanks
@hemanttoday4 жыл бұрын
Great work.
@pasito2872 ай бұрын
very useful tutorials till now
@TheAndozio4 жыл бұрын
THANKS FOR THE GREAT VIDEO.
@bnguyenp68 жыл бұрын
same here . This is a brilliant explanation
@AngeloBommarito5 жыл бұрын
Your videos are excellent, and easy to understand. Thank you very much. You should get these on Khan Academy
@kokosda2 жыл бұрын
Greate explanation, bro!
@NaveedAmwani19 жыл бұрын
wonderful explaination
@stephane777_8 жыл бұрын
thank you kudvenkat, really helpful ! I am gonna subscribe :)
@chitranjansoni24557 жыл бұрын
excellent explanation...over the vedio on youtube.
@alekseyr73948 жыл бұрын
It's just perfect, thanks!
@ananthasubramanian73555 жыл бұрын
Thank you for a nice video
@Chinnurockbells11 ай бұрын
good example sir
@hungrymynd56737 жыл бұрын
Great tutorial. Thank you!
@arkalahiri87494 жыл бұрын
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?
@sandeepbabusirisinagandla25046 жыл бұрын
Good explanation...!
@chesterchaz1354 жыл бұрын
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 ?
@deepakbhagat8115 жыл бұрын
thank you this tutorial is very informative
@pparturo20077 жыл бұрын
Excellent explanation.
@RAlvTorre5 жыл бұрын
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.
@AshProgHelp5 жыл бұрын
thanks for this tutorial
@romeror19455 жыл бұрын
great video
@rajenshah80327 жыл бұрын
Excellent explanation...
@7116matrix8 жыл бұрын
Awesome lesson, thanks!
@dnadelson8 жыл бұрын
amazing as always.
@epicwhat0017 жыл бұрын
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
@sajadahanger94994 жыл бұрын
Loved it!
@julianatlas51724 жыл бұрын
good info, thanks!
@tam15868 жыл бұрын
Great explanation! Thanks! :)
@aartibhatia84156 жыл бұрын
Hello Sir, u r my Guru. Please provide us tutorials for Optimisation. It's a request..
@meettoraju5 жыл бұрын
Brilliant...
@michaelmauter36706 жыл бұрын
Nice video, thank you!
@younesshaimi14507 жыл бұрын
great job
@tharif4me9 жыл бұрын
Nice Article...Thanxx....Bro
@dasarivenkatachalapathi63116 жыл бұрын
good explanation
@luigizambetti186 жыл бұрын
Hello Kudvenkat, just a question: all the videos in this playlist could be enough for preparing to 70-761 certification exam?