I was just curious so I wrote a quick loop to see what the results would be. Due to the way SQL Server handles Decimal/Numeric multiplication you need to set the scale really high to get a precise result:DECLARE @Val DECIMAL(38, 37) = 1.0116666666666667;
DECLARE @Exponent INT = 120;
DECLARE @Result DECIMAL(38, 37);
WHILE @Exponent - 1 > 0
BEGIN
SET @Result =
CASE
WHEN @Result IS NULL THEN @Val * @Val
ELSE @Result * @Val
END
SET @Exponent = @Exponent - 1
END
SELECT @Result
RESULT: 4.0224706411581114419518589580496877300