In this video, I show how we can use the APPLY operator to find records associated with a “parent” table. We look at getting the latest record, as well as any arbitrary number of records. We also spend time digging into under what circumstances the APPLY operator out-performs other common options.
During the outro segment, I dig into under what circumstances APPLY is the best tool for the job, so stick around for the end.
[…] I have to come up with my own. Erik’s video is actually a really good companion piece to my video that also dropped this week, as we both cover the same general […]