vendredi 6 mai 2016

SQL Server : whole number without rounding Issue

I am running below query I am expecting value of 300 (I am getting in Excel). I want to get value 300 without rounding.

declare @a decimal(20, 10)

set @a = (1.00000 / 33.00000)

select @a

select @a * 9900 (0.0303030303 * 9900 = 300 in Excel).

In SQL Server, the result is 299.9999. I want to get 300 without rounding. I am using SQL Server 2005.

Aucun commentaire:

Enregistrer un commentaire