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/