Any way to optimize this query?

[MrNorth]

SELECT  LineActivityLog.* 
FROM  LineActivityLog 
WHERE  LineActivityLog.LineActivityLogID = 
(SELECT DISTINCT MAX(LineActivityLog.LineActivityLogID) 
FROM LineActivityLog      
WHERE LineActivityLog.LineID = @LineID AND LineActivityLog.EndTime =  
(SELECT DISTINCT MAX(LineActivityLog.EndTime)
FROM LineActivityLog 
WHERE LineActivityLog.LineID = @LineID))

It eats a lot of CPU according to our SQL Server logs, and it is run quite frequent. I was thinking maybe we can use CTE instead of distinct max?

we use sql server 2005

/S