[SQL] Best way to do this query..

[Henry Ortega]

I have the following:

name      effective         tstamp                                   rate
John       01-01-2006     2005-12-07 13:39:07.614945    115.00
John       01-16-2006     2006-01-07 13:39:07.614945     125.00
John       01-16-2006     2006-01-09 15:13:04.416935    1885.00

I want the output to be:
name      effective         end_date        rate
John       01-01-2006     01-15-2006    115.00
John       01-16-2006                         1885.00

What is the best way to do this? This is on a huge table and what I
have right now is quite slow. Any ideas?