Jeff Moden (5/21/2008)
Heh... I started reading this post and then saw your first reply... I knew you'd use the running balance trick... it just makes sense, here. Nicely done!
Thanks - it's also the only other way I could think of doing it...:) Well - the only "sane" way. There's always the "dual-ledger, dual updatable cursor" method....:D It would probably still be running for the first time on a 1M row test...
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?