Home Forums SQL Server 2008 T-SQL (SS2K8) Arithmetic overflow error converting numeric to data type numeric RE: Arithmetic overflow error converting numeric to data type numeric

  • That's because 16 is the full length. From those 16 positions you need to substract 4 for decimal positions. That gives you 12 positions on the left and 4 positions to the right.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2