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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scaling results in data truncation 2
Query is Truncating Data 10
Query ask for parameter value? 2
Issue with absolute walues in a yes/no table 6
System Resource Exceeded/Query Too Complex 4
Running Sum Query of Ranked Data 6
Replace result of 0 with empty string (null) 2
Finding Last field with value 3

Top