title: TSQL So weird, dividing doesn't work in select (but * - + works fine), but only for one column
body: <p>I have so weird issue:</p>
  
  <pre><code>select ****
  COALESCE(Customers / (NULLIF(Visitors,0)),0) AS CR
  </code></pre>
  
  <p>for 3/3 returns 1
  for 157/2 returns 0 
  or any other non 1 will return 0.</p>
  
  <p>The CR is decimal(8,2) and for all other columns the same line is working (with mix of different columns)</p>
  
  <p>I have tried + - *, all works as should, however as soon I use division it won't return a value unless is one.</p>
  
  <p>What is going on ??? Why dividing doesn't work, while all other arithmetic functions works just fine. Looks like it won't return decimals...</p>