Aha! Decimal must be immune to a true round::

Try this one!

DECLARE @Gains AS float

SET @Gains=RAND()

SELECT

@Gains

, ROUND(@Gains, 4)

so maybe in your code you could cast to a float and round it.

~BOT