I am using a code similar to the one below inside my stored procedure:
declare @tempVar decimal select @tempVar = amount from tempTable where <<conditions>> IF (CONDITIONAL STATEMENT) BEGIN select @tempVar END
now I am supposed to be getting 4.25 something and I get 4, when I can clearly see in the table that this particular value is not just 4. So why is the rounding take place? Anybody know what I am missing here?