How to get percentage in TSQL when dividing 2 integers?

Question

I'd like to display this division as a percent.

SELECT a * 100/b
FROM myTable
WHERE condition 

Here, for instance, a = 170, b = 288. a / b = 0.590277777778.

I'd like to return 59,02. What I'm getting is only 59. How to get both parts?

Answer 1

Sql Server sees only integer arguments and returns integer result. Make one of two first arguments numeric / decimal

select a * 100./b

or

select cast(cast(a as decimal(18,4)) * 100/b as decimal(18,2))

this will not help:

select a/b*100.

because of the order of operations first opeation ( division )is still integer.

Test case to play with

declare @a int=170,
        @b int=288;

select  cast(@a as decimal)*100/@b   --59.02777777777
      , @a*100./@b  --59.02777777777
      , cast (@a*100./@b as decimal(18,2)) --59.03