This is because the create table function produced by csvsql neglected to specify the precision and scale of the decimals: 42.4242424242 changes to 42 because the type of this row is DECIMAL (10,0).

Structured Query Language (SQL) Note. Contribute to Unique982/Structured-Query-Language-SQL- development by creating an account on GitHub.

When you define a column in MS SQL server as either decimal or numeric (these are both options but do the same thing) you need to define a fixed precision and scale value for that column.