title: More concise way to cast division of integers to decimal
body: <p>I'm trying to divide some integers to get a percentage.  By default I get an integer result, of course, so I cast to decimal.  But I also would like the result to only have two places to the right of the decimal.</p>
  
  <pre><code>--select (x - y) / y
  
  select (82 - 56) / 56                                      --0
  select (82 - 56) / cast(56 as decimal(9, 2))               --0.4642857142
  select cast(82 - 56 as decimal(9,2)) / 56                  --0.464285
  select cast((82 - 56) / 56 as decimal(9,2))                --0.00
  
  select cast(cast(82 - 56 as decimal) / 56 as decimal(9,2)) --.46
  </code></pre>
  
  <p>So I end up having to cast both one of the operands and the entire expression in order to get the result I want.  Is there a better way to do this?  </p>
  
  <p>Notice I put the equation up top to signify that I am obviously not working with hardcoded numbers (i.e. Suggesting I just put ".0" after the numbers would be less than helpful).  Also, I would normally leave the formatting aspect to reporting software, but this is being copied from time to time into an excel spreadsheet and I would have to hand format it every time.</p>