Hi,
If i understood the problem (you did not show the result set)
I think that you can also write this query this way (sql 2000/2005):
SELECT
lvt.ID,
lvt.PhoneNumber,
lvt.CreateDate,
lvc.CallWindowStart,
lvc.CallWindowEnd,
lvc.LVCallDispositionID
FROM
LVTransaction lvt
INNER JOIN
LVCall lvc
on (lvc.LVTransactionID = lvt.ID
and lvc.CreateDate in
(select top 3 CreateDate
from LVCall lvc1
where lvc1.LVTransactionID = lvc.LVTransactionID
Order By CreateDate DESC))
order by lvt.ID,lvt.CreateDate
But it doesn't show as good preformance as the others (Cross Aplly & Row Number).
Rani_w