• Does a regular correlated sub-query perform the same thing?

    SELECT

    lvt.ID,

    lvt.PhoneNumber,

    lvt.CreateDate,

    lvc.CallWindowStart,

    lvc.CallWindowEnd,

    lvc.LVCallDispositionID

    FROM

    LVTransaction lvt

    OUTER APPLY --<<<<<<<<<<<<<< Replace OUTER APPLY with WHERE.

    (

    SELECT top 3 *

    FROM LVCall

    WHERE lvtransactionID = lvt.ID

    Order By CreateDate DESC

    ) as lvc