My values in money column are changed when bulk insert is used

Question

I have a table where I store amount in money. When I used to insert these values from my that table to another table; values changes.

In my first table value of a column 'PRICE' is 130 but when bulk insert was used, it was inserted as 129.60 in another table.

My bulk insert command is:

Insert into InvoiceDetail(InvoiceId,AgentId,ProductCode,BrandId,Qty,Price,ProductType)
 Select SCOPE_IDENTITY(),'12736387',ProductCode,BrandId,Qty,M2CPrice,ProductType from 
UserPackages where AgentId='12736387'

Are the datatypes of the columns storing the money in both tables the same? — Nick Otten, Jun 02 '15 at 08:04
Yes these are same, but I think @rahul-tripathi says right... — Sarbjit Singh, Jun 02 '15 at 09:48
I agree, we posted more or less at the same moment so I didn't see his answer in time. — Nick Otten, Jun 02 '15 at 11:15

score 0 · Accepted Answer · edited Jul 29 '20 at 18:21

0

I would recommend you to use decimal/numeric instead of money as money is not precise. You can check Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?

Do note that MONEY data type has rounding errors. Also performance wise decimal is better. Check the blog by Aaron Bertrand: Performance / Storage Comparisons : MONEY vs. DECIMAL

edited Jul 29 '20 at 18:21

Community

1
1

answered Jun 02 '15 at 08:04

Rahul Tripathi

168,305
31
280
331

My values in money column are changed when bulk insert is used

1 Answers1