How to use the divide function in the query?

sql, sql-server, sql-server-2005, sql-server-2008

Solution

Assuming all of these columns are `int`, then the first thing to sort out is converting one or more of them to a better data type - `int` division performs truncation, so anything less than 100% would give you a result of 0:

select (100.0 * (SPGI09_EARLY_OVER_T – SPGI09_OVER_WK_EARLY_ADJUST_T)) / (SPGI09_EARLY_OVER_T + SPGR99_LATE_CM_T  + SPGR99_ON_TIME_Q)
from 
CSPGI09_OVERSHIPMENT 

Here, I've mutiplied one of the numbers by `100.0` which will force the result of the calculation to be done with `float`s rather than `int`s. By choosing `100`, I'm also getting it ready to be treated as a `%`.

I was also a little confused by your bracketing - I think I've got it correct - but you had brackets around single values, and then in other places you had a mix of operators (`-` and `/`) at the same level, and so were relying on the precedence rules to define which operator applied first.

Problem

Original source