Roy,

<< Is that just down to network traffic or something else? >>

Yep, just network traffic and turnaround time on each request.

Tim Young
Elevate Software
www.elevatesoft.com

If there is only 1 record per date then using Fernando's query.  If there are multiple records per date add a unique field to the select list/group by and use that (unique key) as the join for the update.

SELECT
   MyDate, MyAmountPositive, MyAmountNegative, RUNSUM(coalesce(MyAmountPositive,0) - coalesce(MyAmountNegative,0)) AS MyTotal into memory\temp from mytable
 GROUP BY
   MyDate;
update mytable set mytotal=temp.mytotal from mytable join memory\temp on mytable.mydate=temp.mydate;
drop table memory\temp

John

John


I knew you could do it - how's life in Edinburgh?

Roy Lambert

Hi Roy,

Been very busy with work and lots of golf!  Scotland is such a wonderful place when we get a bit of sun (must be especially gorgeous where you are).

Hope life is treating you well.

John

John


>Been very busy with work and lots of golf! Scotland is such a wonderful place when we get a bit of sun (must be especially gorgeous where you are).

Nah! To dammed hot. I didn't move up here to sweat all day

>Hope life is treating you well.

Life is - the economy still isn't but we're being told all the time its improving so there's still hope.

Roy