Greg,
> > command in ms-sql 7 can use calculate field (column) balance from id=1
> > to id=4: "update xx set bal=balance=bal+debet-credit"
>
> You cannot do such a thing in SQL alone: you must use a procedural
> language. One way is with plpgsql:
You're mistaken, I think (I can't find the origi
On Thursday 06 Feb 2003 10:10 am, betty wrote:
> Hi..
>
> I have table xx:
> id debet credit balance
> 1 10000 0
> 2 2000 0 0
> 3 0 2500 0
> 4 0 100 0
>
> command in ms-sql 7
>
> I have table xx:
> id debet credit balance
> 1 10000 0
> 2 2000 0 0
> 3 0 2500 0
> 4 0 100 0
>
> command in ms-sql 7 can use calculate field (column) balance from id=1
to
Hi..
I have table xx:
id debet credit balance
1 10000 0
2 2000 0 0
3 0 2500 0
4 0 100 0
command in ms-sql 7 can use calculate field (column) balance from id=1 to
id=4:
"upda
