So I got a little closer with the following code change. Added a second variable into the mix and it works except it gets day 2's "yesterday" value wrong...

WayneS (3/25/2011)

---

1. Is the end result the output from the select, or do you need those two columns updated in the table?

2. Are the DayID_in values always going to be...

opc.three (3/25/2011)

---

What will be consuming your results? Doing this kind of work else outside the DB is also a viable option. Most reporting tools have built-in functionality well-suited for solving...

yes 2008, sorry didn't notice the wrong group...

Tried static forward read only cursor and on millions of rows is extremely slow compared to the update. Have not tried with CLR but may be worth looking into....