Okay,

Well, I have to admit...i was focused on the wrong thing all the time.

managed to get both methods working...10006 rows later, update was faster..by 11 seconds!

means I can do away...

trxdate is never null.

I modified what you did with the cursor...and it works:

--Here is your cursor method

DECLARE RunningTotalCursor

CURSOR LOCAL FAST_FORWARD FOR

SELECT rawtrxid, forcount, emppin

FROM rawtrx

ORDER BY rawtrxid

OPEN RunningTotalCursor

DECLARE @rawtrxid INT

DECLARE...

Thanks for the reply...I went, took a shower n couldnt sleep till i got this thing figured...so i worked with the quirky update thing...got this:

/*************************************************************************************

Pseduo-cursor Running Total update using...

no inserts.

no ddls

sample data:

rawtrxid forcount emppin RunningTotal

----------- ----------- ----------- ------------

7 ...

Im doing it in sql server 2005...management studio express

I used the nested subquery method in ms access before and it was slow.

You need to post ddl ( create tables scripts),...

I read that article about 100 times.

I read about 100 articles comparing different types of running sum...of which:

clr is the best way to do it but i cant get pass...