<div>
That gave me the information I needed to complete the problem. &nbsp;The final solution for me was:<br />
CAST(num*1.0/num as numeric(10,2)) as rate<br />
<br />
Thanks! 
</div>


That gave me the information I needed to complete the problem.  The final solution for me was:
CAST(num*1.0/num as numeric(10,2)) as rate

Thanks!

<div>
<div class="content wysiwyg-content">
I have what seems to be a very easy problem, but it isn't working for me. &nbsp;I have a table with two integer value columns (A and B). &nbsp;I simply want to create a new table with a new column (C) that divides column A by column B and gives me a result in a rate or percentage form. &nbsp;<br />
<br />
For example, row 1 may contain 4 for column A and 16 for column B. &nbsp;I would expect my new computed column C to show .25 (4/16) or 25 (4.16*100). &nbsp;<br />
<br />
I have used several combinations of CAST, ROUND, CONVERT with DECIMAL and NUMERIC, but can't get the correct result. &nbsp;I can't wait to see the simple solution.<br />
<br />
Thank you so much.
</div>
</div>


I have what seems to be a very easy problem, but it isn't working for me.  I have a table with two integer value columns (A and B).  I simply want to create a new table with a new column (C) that divides column A by column B and gives me a result in a rate or percentage form.  

For example, row 1 may contain 4 for column A and 16 for column B.  I would expect my new computed column C to show .25 (4/16) or 25 (4.16*100).  

I have used several combinations of CAST, ROUND, CONVERT with DECIMAL and NUMERIC, but can't get the correct result.  I can't wait to see the simple solution.

Thank you so much.

How do I divide two integer values and get a result that includes 2 decimal places?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.