The APPLY operator is similar to the JOIN operator, however it specifically allows you to use table functions with parameters to join the results.
table1
column ------ a1 a2 a3 a4 a5
Using the query below, CROSS APPLY will join the result of the function once per row based on the passed parameter.
SELECT DISTINCT a.column, b.* FROM table1 a CROSS APPLY myFunction(a.column) b |
