sql server correlated subquery

A correlated subquery is a subquery that uses the values of the outer query  and it is evaluated for each row processed by the outer query 

A correlated subquery  always depends on outer query for its value. Because of this dependency, a correlated subquery cannot be executed independently as a simple subquery .