question on getting cumulative % and other

From: Hongjiew <hongjiew_at_aol.com>
Date: 27 Nov 2000 00:12:17 GMT
Message-ID: <20001126191217.23338.00002100@ng-fv1.aol.com>

Dear friends:

I try to accomplish the following:

table

department revenue perctage

1                100         0.10
2                200         0.20
3                400         0.40

...

I want to write a simple query to generate the cumulative percentage,

In other words,

department  revenue     cum
1                100            0.10
2                300            0.30
3                700            0.70 

...

Also, I like to create a triger on a transaction table such that it will invoke a procedure which in term is updating a summary table based on the transaction table.

Please help.

Thanks.

hongjiew_at_aol.com Received on Sun Nov 26 2000 - 18:12:17 CST