Lowell (1/13/2009)

---

i would not put the counter_id data in the table...instead i would make a view which had the value you were looking for:

[font="Courier New"]

SELECT      Row_number() OVER (PARTITION BY x.chk_no...