Not being a SQL programmer please forgive the following but I need to know.
I have a MSSQL database with a table containing a row defined as
Column Name Data Type Length
Turnover decimal 5
also in Enterprise Manager I see Precision is set to 7 and Scale is set to 2.
Is it possibly that the max value could be limited to 9999,99 and if so what needs altering to allow up to 1000000,00?