[scolty]

Morning, Im curious as to what you guys would suggest regarding the following issue(im not 100% sure it is one).

Below is a screen dump showing the original data on the right, and the data that was imported on the left. Obviously the left contain the additional digits because it a float and has to approx a value.

[QUESTION] could this possibly be an issue?? I have a gut feeling that it could be if im performing alot of addition/subtraction operations on the data.

[QUESTION]If i am correct, is there a way to round each of the values automatically??

Thanks again for your help

This post has been edited by scolty: 26 January 2012 - 05:08 AM

[nK0de]

seeing the 2 columns' names as bidPrice and askPrice, I suppose those columns store currency values, am I right? Don't use float for that.
I guess you're using SQL Server 2008.. I suggest you use the data types money or smallmoney which are specifically to store currency values. read about it here

Or you can use decimal data type too. And you can even set the precision point.