Yes, let's use the sample data "1799102776.32000" to explain the reason why it can't be converted into expected data type.
The left side of decimal point is 1799102776, and it has 10 digits, but the data type "NUMERIC(15,6)" could only store 15-6=9 digits. When you use cast function to convert it, you would get "Arithmetic overflow error" message.
Further more, if you insist on doing that, it would lead to loss precision.
Best Regards,
Will
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.