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