CODEWITHSUNDEEP
ssis
lollancf37
lollancf37

Reputation: 1125

Problem with numeric values

I have a package where I insert a numeric table from a view into an other table. My problem is that in my final table, my values are not the same and I do see anything particular done. By example : If I have 6579207.48 in my referece table, I will have 6579207.00 in my destination table.

I know I'm not super precise hear however did anyone came accross a case like this ?

Upvotes: 0

Views: 122

Answers (1)

Josef Richberg
Josef Richberg

Reputation: 613

What are the data types? float is approximate, whereas numeric/decimal are exact.

Upvotes: 1

Related Questions