"Martin... I haven't forgotten you on this problem... I just got a little overwhelmed with a bunch of other stuff including some duties at work (not to mention the 2:15...

Jeff Moden (11/13/2009)

---

Dang it... you're right, Martin. Dyslexia due to lack of coffee must have kicked kicked in. My apologies. I'll check it out.

Or maybe it's the...

Jeff Moden (11/12/2009)

---

Ok, Martin... I'm confused... I see that all of your code examples update the "RunningBalance" column... none of the code updates the "RunningTotal" column yet your complaint is...

[/quote]

Martin, before I can check it out, I need some additional information... I need you to generate the CREATE TABLE statement and the code for all the indexes, please.[/quote]

Jeff

Here...

Hi Jeff as requested here is the code used and the output from my...

Jeff Moden (11/11/2009)

---

Martin Butcher-415798 (11/11/2009)

---

Hi Jeff

Thanks for the very well written article. I had tried something very similar myself some time ago but could never get it to work accurately....

Hi Jeff

Thanks for the very well written article. I had tried something very similar myself some time ago but could never get it to work accurately. The logic always looked...