Prevent rounding in SQL

See more:

SQL

My query is rounding decimal values to integer. I understand the syntax of decimal(integers,decimals) itself however I do not understand how I implement this in my query. I do not see an answer which specifically addresses this so, if there is one, please simply point me to it.

I am running the following query within a VBA macro within Excel so I would think I am using MS SQL, please correct me if I am in error.

SELECT * from DateSlicedCDR.csv AS Q LEFT OUTER JOIN AreaCodes.csv AS R ON Q.[AreaPrefix] = R.[AreaPrefix] ORDER BY [BeginTimeDate] ASC

I realize csv files are by no means the ideal however I want to leave that aside for the moment and get the query straightened out then later perhaps change the data format to something better and faster.

What is happening is that one of the fields, which has a variable number of decimal places (max 7 decimals), is getting rounded so that when I write out the table created from my join, I no longer have the correct values.

If I have to explicitly state the fields instead of *, that is fine.

If I have done anything wrong in the posting of this question, or if you need additional information, please let me know as I am relatively new to the site.

Thank you.

What I have tried:

I looked at the field in the record set produced by my query and could see that the values had been rounded to the nearest integer. I searched the web and found that it appears I need to implement the decimal statement, but I can't find an example of how to do it.