• The apply-operator was introduced to "join" the result of a function to a resultset. That was not possible before the apply-operator.

    When using a table expression for joining there is no general answer whether you should use the one or the other.

    The only thing you can do is: analyse the execution plans!

    If you need some more information about your example queries, give us your execution plans or provide some example data.