My client's system is very outdated, and there is nothing I can do about it. What I'm trying to achieve is to extract values always with at least 2 decimal places.
1826.5695600000 1826.3000000000 34.2300000000 0.0030000000
1826.56956 1826.30 34.23 0.003
If I cast these values as
money I lose everything after 4th decimal place, but I need to achieve something similar but with min 2 max 10 decimal places. It does not matter if it is a string at the end, all that matters that I can extract value in this format.
My first try was to cast to float, find decimal point and accordingly cast the value as decimal(20,variable) but that was impossible, so I am now stuck in my mind how to achieve this.
These values are going trough SSIS processes
- Extracted from Database
- Pushed to client's import file