Re: SQL server 6.5 mis(t)ery
Hi Cakkie
Haven't used SQL6.5 for a few years, so I can't even remember if it had a money dt. Try convert to a money then to decimal and check if there is any difference?
Re: SQL server 6.5 mis(t)ery
Been there, done that, still wrong
Tom Cannaerts
[email protected]
Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook
Re: SQL server 6.5 mis(t)ery
I use Sybase here and it doesn't exhibit that behaviour.
Try using:
convert(smallmoney,(amount * unitprice)))
HTH,
Duncan
-------------------------------------------------
Ex. Datis: Duncan Jones
Merrion Computing Ltd
http://www.merrioncomputing.com
Re: SQL server 6.5 mis(t)ery
I put your data into my Sql Server 7 database and it works fine maybe you need a service pack for SQL 6.5 (If there's one available) cause it may be a bug
Re: SQL server 6.5 mis(t)ery
I applied servicepack 5a two week ago, up until that, that was the latest.
Tom Cannaerts
[email protected]
Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook