quote:

---

Originally posted by webfred

select id, updateTime, fname, lname from
(select row_number() over (partition by id order by updateTime DESC) as rnum,* from YourTable)dt
where rnum=1

---

Too old to Rock'n'Roll too young to die.

---

SELECT
	a.id,
	CASE WHEN c.updatetime > b.updatetime THEN c.updatetime ELSE b.updatetime END AS updatetime,
	b.fname,
	c.lname
FROM
	(SELECT DISTINCT id FROM  Tbl) a
	OUTER APPLY 
	(
		SELECT TOP 1 b.updatetime,b.fname FROM Tbl b 
		WHERE b.id = a.id AND b.fname IS NOT NULL
		ORDER BY updatetime DESC
	)b
	OUTER APPLY 
	(
		SELECT TOP 1 c.updatetime,c.lname FROM Tbl c 
		WHERE c.id = a.id AND c.lname IS NOT NULL
		ORDER BY updatetime DESC
	)c