Re: [SQL] Creating Stored Procedures

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, 200

Re: [SQL] Accumulated sums in SQL query

Thank you Christoph this logic helped me a lot. Regards Joseph - Original Message - From: "Christoph Haller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 1:27 PM Subject: Re: [SQL] Accumulated sums in SQL query > > > > OK I have a tab

Re: [SQL] Accumulated sums in SQL query

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: D&C balance --- 11 34 -2 2 5

[SQL] Accumulated sums in SQL query

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