How to chop-off the decimal digits without allowing the rounding?
In one of the procedures, I have a temp table, designed to be exactly the same as the destination table, wherein the data will be finally dumped. A column of that temp table is rate decimal (6,5) not null I will be storing decimal data into this, which comes computed from another part of the stored procedure, and therefore the digits after the dcimal can sometimes exceed 5 (example 0.01263789). When I try to store data in the rate column, it is getting automatically rounded-off to 0.01264. But I want the final value as 0.01263. Is there a way in SQL Server 2008 that I can simply chop-off the decimal digits without allowing the rounding?