>Here's one solution with a CTE and then 2 correlated subqueries. If there's a risk of a tie (2 names for the same date), you could do a SELECT TOP 1 Name
>
>As I look at this, I'm pretty sure there's an easier way. I'll post again if I can think of one (or maybe someone else has an idea).
>I'm sure there are variations of this that could be done with CROSS APPLY and other approaches, but this at least should work.
>
>

>;WITH TempCTE AS (SELECT ClientNo, MAX(AddDate) as MaxDate, MIN(AddDate) as MinDate
>                                     FROM dbo.Test  GROUP BY ClientNo)
>
>
>SELECT TempCTE.ClientNo , 
>        (SELECT Name from dbo.Test  WHERE TempCTE.ClientNo = Test.ClientNo AND Tempcte.MinDate = Test.AddDate) as FirstName, 
>        (SELECT Name from dbo.Test  WHERE TempCTE.ClientNo = Test.ClientNo AND Tempcte.MaxDate = Test.AddDate) as LastName
>FROM TempCTE 
>

Thanks, that is another possible way.