joygomez

<div>
It's probably treating 1 and 4 as integers, losing precision, so the result is rounded to 0. &nbsp;Adding a decimal, like with 0.25 or 1/4.0 implicitly converts the values to a data type that preserves the fractional number. &nbsp;You could also use an explicit cast to do the same thing CAST(1 as decimal) / CAST(4 as decimal)
</div>


It's probably treating 1 and 4 as integers, losing precision, so the result is rounded to 0.  Adding a decimal, like with 0.25 or 1/4.0 implicitly converts the values to a data type that preserves the fractional number.  You could also use an explicit cast to do the same thing CAST(1 as decimal) / CAST(4 as decimal)

<div>
Never mind. &nbsp;Too late :-)
</div>


<div>
<div class="content wysiwyg-content">
In Sql Servicer, I am unable to do a calculation of 1/4 and place it in column with decimal (18,4). &nbsp;However when i place the value .25, it accepts it.<br />
<br />
below is the query.<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UPDATE ExactCostLaborTimings_Work<wbr />ingTbl_Gra<wbr />nular<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ExactCostLaborTimings_Work<wbr />ingTbl_Gra<wbr />nular.Divi<wbr />dingFactor<wbr /> =1/4
</div>
</div>


In Sql Servicer, I am unable to do a calculation of 1/4 and place it in column with decimal (18,4).  However when i place the value .25, it accepts it.

below is the query.

			UPDATE ExactCostLaborTimings_WorkingTbl_Granular
			SET	   ExactCostLaborTimings_WorkingTbl_Granular.DividingFactor =1/4

SQL unable to place calculation of 1/4 into a column (decimal (18,4)

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.