Código SQL:
Ver originalCREATE TABLE #temp
(
id INT,
fecha datetime,
nombre VARCHAR(50)
)
INSERT INTO #temp VALUES(1,'2011-10-28 00:00:00.000','q')
INSERT INTO #temp VALUES(2,'2011-10-30 00:00:00.000','w')
INSERT INTO #temp VALUES(1,'2011-11-01 00:00:00.000','r')
INSERT INTO #temp VALUES(2,'2011-11-03 00:00:00.000','t')
INSERT INTO #temp VALUES(1,'2011-11-05 00:00:00.000','y')
INSERT INTO #temp VALUES(2,'2011-11-07 00:00:00.000','u')
SELECT id,nombre,fecha FROM #temp WHERE id=2 AND fecha=(SELECT MAX(fecha) FROM #temp WHERE id=2)
Saludos!