I have the following:<br /><br />name effective tstamp rate<br
/>John 01-01-2006 2005-12-07 13:39:07.614945 115.00<br />John 01-16-2006 2006-01-07
13:39:07.614945 125.00<br /> John 01-16-2006 2006-01-09 15:13:04.416935 1885.00<br /><br />I want the
outputto be:<br />name effective end_date rate<br /> John 01-01-2006 01-15-2006
115.00<br/> John 01-16-2006 1885.00<br /><br />What is the best way to do this? This is
ona huge table and what I<br />have right now is quite slow. Any ideas?<br /><br /><br />
