Column or parameter #%d: Specified column scale %d is greater than the specified precision of %d.
This error occurs when the scale of a decimal or numeric column exceeds the precision value for that column.
For decimal and numeric data types, Microsoft® SQL Server™ normally supports a maximum precision of 38 digits for compatibility with various applications. For more information about running the sqlservr application, see sqlservr Application.
Specify the precision with p, which must be between 1 and the maximum precision, and the scale with s, which must be between 0 and p. If you do not specify the precision, SQL Server uses a default precision of 18. If you do not specify the scale, SQL Server uses a default scale of 0.