hidrau
asked on
Arithmetic overflow error converting float to data type numeric
Hello guys,
I have a query that is resulting me an error:
Arithmetic overflow error converting float to data type numeric
How could I get the row that is resulting me this error?
Thanks
Alex
I have a query that is resulting me an error:
Arithmetic overflow error converting float to data type numeric
SELECT
convert(numeric(14,2),round(convert(numeric(17,8),qtdpro)*round(convert(numeric(17,8),prunit)*convert(numeric(17,8),(1-(a.pdes/100)) ), dbo.fn_DigitosValor()) +convert(numeric(17,2),(a.FRETE+a.SEGURO+a.OUTDESP),2),2)) as BASCSLL
from aripco a,arpco b
where (a.numped = b.numped and a.seqped = b.seqped)
and qtdpro > 0
and prunit > 0
and b.flagoriginal = 0
and (B.FLAGFINALIZADO = 0)
How could I get the row that is resulting me this error?
Thanks
Alex
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot
ASKER