Dividing in SQL

SQL server division is typically required when you want to find out entities that are interacting with all entities of a set of different type entities. The division operator is used when we have to evaluate queries which contain the keyword 'all'. 7 You are doing an integer division first and then convert the result. The integer division results in 0. Converting 0 to NUMERIC(10,3) results in 0.000.

SQL Fiddle nMS SQL Server 2008 Schema Setup:

Query 1: SELECT 20/1024; Results: | COLUMN_0 | ------------ | 0 |

To get a non-integer-division you need to convert at least on of the two numbers involved to something other than an integer. In the case of number literals you can just add a . after the digits:

Query 2: SELECT 20./1024; Results: | COLUMN_0 | ------------ | 0.019531 |

In the case of variables or columns you need to convert one of them using CAST or CONVERT:

Query 3: SELECT 20/CAST(1024 AS NUMERIC(10,3)); Results: | COLUMN_0 | -------------- | 0.01953125 |