Solved

SQL 2005 - Numbers keep rounding up

Posted on 2009-07-06
3
163 Views
Last Modified: 2012-05-07
I have a data entry form and the numbers keep rounding up.  What SQL 2005 data type will stop this and still allow calculations?

Thanks,
John
0
Comment
Question by:JohnMac328
3 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 250 total points
ID: 24788849
try either
decimal
money
double
float

depends on which calculatations you need, but decimal will probably be the best for you
0
 
LVL 17

Assisted Solution

by:pssandhu
pssandhu earned 250 total points
ID: 24788860
0
 

Author Closing Comment

by:JohnMac328
ID: 31600329
Thanks, now I can format to get the correct display
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question