I have a stored procedure which reads a raw table (all nvarchar) and inputs into a new SQL table
My new table requires a field to have 2 decimal numbers, but at the moment I just use the following:
convert(float,file_a.Amount)
This is returning only whole numbers where there are no decimal places. I know that I need to use the CAST command, but struggling
Many thanks