In my table there is decimal datatype defined as like this decima(30,15). I am getting source data more than defined size like below
0.299999999999999988897769753748434595763683319091796875 . I need to turncate it and load into table. Any sugggestions ?
Thanks in Advance
I notice a space '8 75' in your value.
Is this the problem you need to correct?
If the space wasn't there the value would insert and round off.
The cast fails due to too many digits in your input string.
doesn't fail in cases like that.