‫آشنایی با دستور APPLY در SQL Server

The APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query 

Another Reference