Error MSG: "caling of deciamal value resulted in data truncation"

S

susan hill

when i run this query i get "Scaling of Decimal value
resulted in data truncation." i know this worked at one
time. can anyone help me out? thanks! - susan

SELECT SUM(End_Par) As totalPar, SUM(BkYld*End_Par)/SUM
(End_Par) AS wtdAvgBookYld, SUM(Cur_Coupon*End_Par)/SUM
(End_Par) AS wtdAvgCoupon, SUM(BooKPrice*End_Par)/SUM
(End_Par) AS wtdAvgBookPrice FROM Accounting WHERE Cust_ID
= 'ABTC'
 
Top