0
Someone could explain to me: I made a Join between two tables. Both bring the same value in their fields. And when subtracting one value minus the other, it does not give zero. As this is possible?
E1_SALDO = 990,42
BAIXZ0 = 990,42
SUBTRACAO = 990,42 - 990,42 = 1,13686837721616E-13
1
This happens because the decimal pattern of SQL Server uses '.' instead of ','
To correct your calculation just use the REPLACE function.
https://docs.microsoft.com/pt-br/sql/t-sql/functions/replace-transact-sql?view=sql-server-2017
That should solve your problem:
declare @E1_SALDO decimal = REPLACE('990,42', ',', '.'),
@BAIXZ0 decimal = REPLACE('990,42', ',', '.')
select @E1_SALDO - @BAIXZ0
I don’t think I understand your explanation. In the example I put 990.42. But the calculation is done with values that are in the bank. The subtraction between values occurs for all titles and for the first time, the subtraction of two equal values was not zero. I shouldn’t have to do this conversion for every calculation I do in the bank. I never did it.
Browser other questions tagged sql sql-server sql-server-2014
You are not signed in. Login or sign up in order to post.
What kind of field?
– ramaral
Both are numerical.
– catholiveira
Catharina, probably some column is declared as floating point (real or float). Or both.
– José Diz