And here're some pseudo-queries and the results I expect from them:

select curr, rate

from (................)

where ddate='01-01-2000'

curr rate

---- ---------------------------------------

1 5.0000

2 55.0000

select curr, rate

from (................)

where ddate='02-01-2000'

curr rate

----...

Ok, here's my table and data definition:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

ddate curr rate

-----------------------...