<div>
&gt;i though decimal (6,2) allowed a numbers such as 1234.56<br />
yes, correct.<br />
<br />
please show the code, you must be doing something &quot;wrong&quot; (ie a implicit conversion)
</div>


<div>
thanks. i checked the procedure and sure enough the decimal was type (3,2)<br />
<br />

</div>


<div>
In SQL Server, decimal(3,2) means your data have three digits in total, two on right hand side of the decimal point and one digit on the left hand side of hte decimal point so if you use a value of 10 or larger will get error message. &nbsp;If you change the data type in your stored procedure from Decimal(3,2) to Decimal(4,2) which allow two digits on the left hand side of he decimal point or Decimal(8,2) which allows six digits on the left hand side of the decimal point depending on how big the decimal value you are going to use. Hope this help. &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
&nbsp;I have a stored procedure that updates data in a table. <br />
&nbsp;one of the colums has a data type decimal(6,2)<br />
<br />
the stored procedure works if i plug the value 9.9 into that parameter<br />
but if i try any value of 10 or over then it gives this error:<br />
<br />
error converting data type numeric to decimal <br />
<br />
any ideas why this would be?<br />
i though decimal (6,2) allowed a numbers such as 1234.56<br />
<br />
thanks<br />
richard
</div>
</div>


Hi all,
 I have a stored procedure that updates data in a table. 
 one of the colums has a data type decimal(6,2)

the stored procedure works if i plug the value 9.9 into that parameter
but if i try any value of 10 or over then it gives this error:

error converting data type numeric to decimal 

any ideas why this would be?
i though decimal (6,2) allowed a numbers such as 1234.56

thanks
richard

Error converting data type numeric to decimal (Strange Behaviour)

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.