Posted by David Portas on 11/01/05 11:18

> The table is sorted by timestamp
That's not correct. Tables are always unsorted.

Try:

SELECT idd
FROM datetable
WHERE startdate =
(SELECT MAX(startdate)
FROM datetable
WHERE startdate <= '2005-01-01T02:35:00') ;

--
David Portas
SQL Server MVP
--

[Back to original message]