find nearest meximum date

[Abid06]

Hello,

I need help in writing a SQL statement in MS SQL Server 2000 to select
the latest date (i.e., the date closest to or equal to the current date)
for a given date.

For example, in a table I have the following records:
Date Exchange-Rate
01/Sep/03 0.55
05/Sep/03 0.59
10/Sep/03 0.60

If the given date is 02/Sep/03, then the rate 0.59 should be return.
If the given date is 03/Sep/03, then the rate 0.59 should be return.
If the given date is 04/Sep/03, then the rate 0.59 should be return.
If the given date is 06/Sep/03, then the rate 0.60 should be return.

There is a solution nearest this problem.

Thanks in advanced,

Abid

[ck9663]

Can you explain why

If the given date is 02/Sep/03, then the rate 0.59 should be return.

Isn't 0.55 nearer that 0.59?


~~ CK

[Rabbit]

Select the min date where the dates are greater than or equal to the given date. Use that in a subquery to get the rate you want.