•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,450 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,347 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 8069 | Replies: 10 | Solved
 |
•
•
Join Date: Jun 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi All,
When I run the query:
select (100/50)
It give me "2"... good.
But when I run the query:
select (50/100)
I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?
When I run the query:
select (100/50)
It give me "2"... good.
But when I run the query:
select (50/100)
I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?
•
•
Join Date: Jun 2005
Location: Texas
Posts: 120
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
change the resulting variable to type double
•
•
Join Date: Aug 2005
Location: Seaham, UK
Posts: 187
Reputation:
Rep Power: 4
Solved Threads: 3
Junior Poster
im not too familiar with sql but i would assume it has something to do with data types maybe? for example if it was integer it would only return a whole number such as 2 or 0 in your case, im not too sure about this in sql as i dont do it but generally that could be the problem
•
•
Join Date: Jun 2005
Location: Texas
Posts: 120
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
try doing your calculations before your sql statment
Dim i As Double Dim MySql as string i = 50 / 100 Mysql="Select " & i & " FROM table;" rs.open MySQl,conn,3,3,1
.: We may acquire liberty, but it is never recovered if it is lost :.
irc://irc.rizon.net/#itf
irc://irc.rizon.net/#itf
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
or simply "select 50. / 100"
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 7
Newbie Poster
It will work fine as long as one of the numbers in division is a float or similar.
Try
This will work with any numeric data.
Try
SQL Syntax (Toggle Plain Text)
•
•
Join Date: Apr 2008
Posts: 295
Reputation:
Rep Power: 1
Solved Threads: 41
Posting Whiz in Training
oops wujtehacjusz, you may have a look at issue date
•
•
Join Date: Mar 2007
Posts: 18
Reputation:
Rep Power: 2
Solved Threads: 7
Newbie Poster
•
•
•
•
Originally Posted by tesuji 
oops wujtehacjusz, you may have a look at issue date
Damn you are right...
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Computer Architecture Reference (Computer Science and Software Design)
- Factorial of a number (C)
- Prime Numbers - Help its for college (Visual Basic 4 / 5 / 6)
- Cannot get PAIR::big to just display greater number (C++)
Other Threads in the MS SQL Forum
- Previous Thread: SQL Syntax
- Next Thread: Nested Queries
