| Subject | Re: How to do a running total in SQL |
|---|---|
| Author | Norbert Saint Georges |
| Post date | 2015-10-23T07:17:20Z |
Hi,
execute block
returns (reference varchar(10), due double precision, balance double
precision)
as
begin
balance = 0;
for select
reference,due
from invoices into :reference, :due
do begin
balance = balance+due;
suspend;
end
end
Norbert
execute block
returns (reference varchar(10), due double precision, balance double
precision)
as
begin
balance = 0;
for select
reference,due
from invoices into :reference, :due
do begin
balance = balance+due;
suspend;
end
end
Norbert