How do I construct an update query that will go through the following table and put any col2 and col3 on the same row if they have the same "date" values?

```
ID col1  col2   col3  date
33  10                3/2/2010
35  NULL  200   NULL  3/2/2010
40  NULL  NULL  300   3/2/2010
43  10                3/5/2010
45  NULL  200   NULL  3/7/2010
46  NULL  NULL  310   3/8/2010
53  10                3/9/2010
55  NULL  200   NULL  3/10/2010
58  NULL  NULL  400   3/10/2010

```

New arrangement:

```
ID col1  col2   col3  date
33  10                3/2/2010
35  NULL  200   300   3/2/2010
43  10                3/5/2010
45  NULL  200   NULL  3/7/2010
46  NULL  NULL  310   3/8/2010
53  10                3/9/2010
55  NULL  200   400   3/10/2010

```

Notice the change for dates 3/2/2010 and 3/10/2010 for col2 and col3 only. These are on the same row and the extra/old entries have been deleted.