Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Data type decimal is rounding off

Author  Topic 

kevindrys
Starting Member

7 Posts

Posted - 2013-02-01 : 12:48:45
There has to be something obvious that I'm overlooking here. I have data in a SQL Server 7.0 table that has data type numeric(18,3). I have an equivalent table in SQL Server 2008 R2, but it has data type decimal(9,3). The data in the 7.0 table is -0.031, but the data in the 2008 table is 0.000. Other examples 1.577 is rounded up to 2.000, .777 is rounded up to 1.000.

I thought the numeric and decimal types were functionally the same. It seems that decimal is the more commonly used. I *thought* I read where numeric may be going away in some future version of SQL Server.

I can use the numeric data type and solve this problem, but I was wondering if I could find an explanation as to yes, decimal rounds off.

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2013-02-01 : 12:51:31
Did you move the data from SQL 7 to 2008R2? If so how?
Go to Top of Page

kevindrys
Starting Member

7 Posts

Posted - 2013-02-01 : 12:56:13
I'm using Import Wizard to pull the data over.
Go to Top of Page
   

- Advertisement -