This is done in Microsoft SQL Server 2008 R2.

I'll start out with an example table.

Code:
    Organization | MoneyAmount | MoneyAmountAvg
    
    ISD          | 500         | 
    ISD          | 500         | 
    ISD          | 500         | 
    QWE          | 250         | 
    ISD          | 500         | 
    QWE          | 250         | 
    OLP          | 800         | 
    ISD          | 500         |
I need the MoneyAmountAvg column to have a value of MoneyAmount/(# of times that organization shows up)

So for example, the MoneyAmountAvg column for the ISD rows would have a value of 100.

QWE would have 125 for each row in the MoneyAmountAvg column and OLP would have a value of 800 since it is there only once.

This is only an example table. The actual table is much bigger and has more organizations, but it has the same criteria. Some organizations have multiple rows, while others are there only once.

I just need a way for it to count how many times each organization is listed when I use an update statement for that organization's MoneyAmountAvg column. Hard coding it for each organization is definitely not an option since they can change at any moment.

Any help is appreciated.