CROSS APPLY could be used as a replacement for correlated sub queries and derived tables.  That’s what we’ll discuss today. I never liked correlated subqueries because it always seemed like adding full blown queries in the select list was confusing and improper. It always seemed to me that these operations should go below the FROM clause.  … Continue reading CROSS APPLY Explained