Im trying to divided the sum of the total column by sum of the same column when account numbers match up.
i have the following sql script done
UPDATE m SET m.AccruedInterest = f.UNITS FROM dbo.NTWorkingDataloadFile1 m INNER JOIN ( SELECT Account_Number, UNITS/(SELECT SUM(UNITS)FROM dbo.NTMercerTransctionHoldingsTable) as UNITS FROM dbo.NTMercerTransctionHoldingsTable WHERE Account_Number=Account_Number GROUP BY Account_Number ) f ON m.MasterIdentifier = f.Account_Number
but getting the follwoinf error
Msg 8120, Level 16, State 1, Line 7
Column 'dbo.NTMercerTransctionHoldingsTable.Units' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
any ideas. i didnt think i had to put the units in the group clause. but when i do i get this error