;
0 = 1/2 / 2
1/4 = 1/2 / 2.0
Kevin Webb
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 6:08 AM
To: CF-Talk
Subject: RE: T-SQL division drops the decimal?
Joshua, I bump into this all the time. You said it is a numeric field
but what is the de
dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to
> [EMAIL PROTECTED]
> **************
> **
> *
>
>
> -Ori
ints/2.0
Since "2.0" looks like a float it will return a float.
Mark
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 12:04 PM
To: CF-Talk
Subject: RE: T-SQL division drops the decimal?
Thanks all for the help, this is wha
PROTECTED]
*
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 11:53 AM
To: CF-Talk
Subject: Re: T-SQL division drops the decimal?
> I have a query that takes a value from the database and
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 11:21 AM
To: CF-Talk
Subject: RE: T-SQL division drops the decimal?
Silly question, but what datatype is the column which holds your result?
Not forgotten about it and left it as an int have you?
Ev
> I have a query that takes a value from the database and divides by 2 and
> inserts that value into another table, however SQL Server (T-SQL) drops
> the decimal place, so 1/2 of 1 is 0 according to T-SQL.
you're telling sql server to divide 2 int, it returns what you asked of it,
an int. i alway
Joshua,
MS SQL automatically returns the type you use. Looks to me like you are
dividing 2 integers.
You need to cast or convert at least one of the numbers to float to get a
float returned.
This got to be such a pain for me that I wrote a function to do the division
(MSSQL 2000).
It converts
Would it be because it's an integer? You may need to use CAST() or
CONVERT().
Ade
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]
Sent: 31 July 2003 16:15
To: CF-Talk
Subject: T-SQL division drops the decimal?
How do others on the list deal with this?
I have a query t
I think it depends on the datatypes you're using as inputs to the division
calculation, if they are integers then it does have problems, you could try
using:
(CAST(myfield AS float))/(CAST(myfield2 AS float)) if myfield1 and myfield2
are integers
Alex
> -Original Message-
> From: Joshua
Silly question, but what datatype is the column which holds your result?
Not forgotten about it and left it as an int have you?
Even if not, I'd play with the datatypes a bit, it may be your issue.
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]
Sent: 31 July 2003 16:15
It's the datatype of the column your holding your information in. Check the
Docs for the correct datatype.
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 11:15 AM
To: CF-Talk
Subject: T-SQL division drops the decimal?
How do others on the l
11 matches
Mail list logo
