Hi!
I have data in the following format :
Table
-----
ID int
Rate decimal(9,2)
EffDate datetime
Data
----
1,200,2005-06-16
1,200,2005-06-17
1,300,2005-06-18
1,300,2005-06-20
1,200,2005-06-21
1,200,2005-06-22
I want to query which shows the Rate along with the validity dates i.e...