As far as I know functions can not return recordsets. Try functions returning cursors
(then FETCH ALL IN..), or temporary tables.
regards Joseph
- Original Message -
From: Philip Van Hoof [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 7:23
Hi,
Which is the simplest way to create an SQL query to get accumulated sums of records
like this (from the table containing the numbers):
numbersums
---
1 1
2 3
3 6
4 10
Thanks in advance
Regards, Joseph
Thanks, but it seems not to be the solution to me, the example was not good enough.
The table for example represents a bank account, records are debits and credits, and
I need the balance in the new query:
DC balance
---
11
34
-2 2
5