Elimination And Updatinig Duplicate Records?

We have a procedure that yields a temp table that has duplicate records as follows:








calc_date
minmaxvalue

1/1/2004
1

1/1/2004
2

1/2/2004
1

1/3/2004
1

1/4/2004
2

1/5/2004
2

1/6/2004
2

1/7/2004
1

1/7/2004
2

1/8/2004
2

1/9/2004
1

1/10/2004
1

1/11/2004
2

1/12/2004
1

1/13/2004
1

1/14/2004
1

1/14/2004
2
We now want to go thru the resulting table and do the following:

if there is a duplicate date record, delete the duplicate and update the remaining minmaxvalue to be 3

the resulting ds would look like this








calc_date
minmaxvalue

1/1/2004
3

1/2/2004
1

1/3/2004
1

1/4/2004
2

1/5/2004
2

1/6/2004
2

1/7/2004
3

1/8/2004
2

1/9/2004
1

1/10/2004
1

1/11/2004
2

1/12/2004
1

1/13/2004
1

1/14/2004
3

Any ideas?