Data conversion error

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ram Ram Ten Centuries Points: 1079 More actions · Answer 1

Ten Centuries

Points: 1079

October 4, 2006 at 6:43 am

Try using FLOAT

SELECT CONVERT(FLOAT,'689.99')

James Mathew SSC Rookie Points: 42 More actions · Answer 2

SSC Rookie

Points: 42

October 4, 2006 at 6:46 am

float gives the same error..

EugeneZ-162636 Default port Points: 1448 More actions · Answer 3

I did not get any error see below: check if you installed fresh sql server service pack

SELECT CONVERT(real,'689.99')

---result---------------------

689.98999

(1 row(s) affected)

---

Jeff Gray SSChampion Points: 10667 More actions · Answer 4

try SELECT CONVERT(real,'689,99')

and see if that works.

Richard Josey Ten Centuries Points: 1076 More actions · Answer 5

Check for differences between the server settings inc. @@MAX_PRECISION and service pack level.

Also any patches which may have been applied to SQL Server.

James Mathew SSC Rookie Points: 42 More actions · Answer 6

Nothing of the above worked , but weekly reboot of server this morning cured the issue... Puzzling!

Richard Josey Ten Centuries Points: 1076 More actions · Answer 7

That would imply a server setting or session setting was changed.

This was then reset to default on reboot.

Not sure what it might be though.

James Mathew SSC Rookie Points: 42 More actions · Answer 8

I think you are right, we got lot of guys playing with servers here...