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