sql
SELECT Convert(decimal(18,2),-1604) /Convert(decimal(18,2),(27615-(-1604))) *100
SELECT 1604/((27615+1604)*1.0) *100
select cast(round((1604/((27615+1604)*1.0))*100,2) as varchar)+'%'
select cast(round(5.48957869879145,2) as varchar)+'%'
-5.4895786987918820
5.48957869879100
5.49000000000000%
5.49000000000000%
select CONVERT(decimal(18,2),1604 *1.0/(27615+1604)*100)
select CAST(CAST(1604*1.0*100/(27615+1604) as decimal(10,2)) as varchar(50)) +'%'
5.49
5.49%
select Round(2.126412,3)
select Convert(decimal(18,3),2.126412)
2.126000
2.126