Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Introduction In Part 1 of this series, we explored the fundamentals of CROSS APPLY and learned how it evaluates a correlated query for each row returned by the outer table. We also saw how it can simplify tasks such as retrieving the latest order for each customer and returning the top N rows within a group. Reporting requirements often go beyond simply returning the latest related row.
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.