Correlated Sub Queries Quickly

SQL Server Unlocked- Correlated Subqueries Quickly
Thanks for returning for another episode of Joes 2 Pros SQL Server unlocked series. Today we will be discussing SQL Server correlated subqueries and how to perform them quickly.
There are many different tips and tricks you can use with SQL Server in order to make your day easier. In the demonstration above, Morelan takes your through an example on how to create correlated subqueries by using a database of a fictional company that has employees and locations in different cities. Sometimes subqueries can be a bit confusing as they are a query nestled inside of another query, but Morelan does a great job creating a simplified example and explanation.
Going through the example step-by-step really helps make sense of what can be a confusing topic. If you would like to learn more about correlated subqueries, please have a look at our Developer 2012 Volume 2 Video 12.2 class.
See more at: www.joes2pros.com/joes2pros/co...
Full Blog: joes2prosblog.social27.com/

[@Slimboyfat1979]

I still dont get it.

[@nicomp1]

I love the hard-coded example. It makes a great point about what not to do. Most classes ignore the negative case.

[@Robay146]

Still don't get it.

[@tekv2]

1:08

[@benbascheable]

I still don’t get it lmao

[@jay___828]

This is very helpful. Thanks a lot

[@tensor2539]

thanks so much, great vid!

[@vickytatto2072]

Thank you so much!!!

[@Ali3hamodi]

So we basically having outer for loop iterating over LocationId from Location Table and the subquery will use that value coming from the outer loop to count the values.

[@nicomp1]

Interesting body language

[@sundew_ii]

huh

[@benbascheable]

I still don’t get it lmao