Using the below query on MsSQL DB, I receive a non float value that is not correct – 10842081
SELECT SUM(CAST(NVARCHAR_column AS FLOAT)) AS kb
FROM table
WHERE 1=1
AND ID IN (1234)
and Time_ > now()
AND Type IN (1,2)
AND Parent = 0
While running the same query on the same DB but from a VM I get a proper result – 4357051.0
On both my PC and VM I’m running RazorSQL 9.5.2, same drivers and everything.
PC is running win 10, VM is with win server 2019. Column is nvarchar
Tried also on other PCs, VMs and a MAC and all return the correct 4357051.0
New contributor
Stephen Todorov is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1