SQL 2008 Add numbers in a column
Posted on 2011-09-23
I have the following:
a database called coop_2011
a table called plantname_usa_inc.
a column called contract_information_total_weight
a column called contract_information_contract
a column called contract_information_weighted_Avg
a view called plant_2011
In this view I filter out several parts of the column called contract_information_contract to select only select contracts.
I now need to be able to total the weightes in the column contract_information_weight for the remaining contracts that have not been filtered out.
After that is completed I need to take the column contract_information_total_weight/the total recieved by adding all the weights still remaining and dump that data in the column contract_information_weighted_Avg