To keep this short and simple, please look at the following two lines to reproduce the problem. I need a solution to store this information NOT floating calculations that trail off into random forever-ness (see my other questions which is why I am using DECIMAL(10,2) in the first place).
Problem is simple. There is an amount being queried from one of my tables for 2479 that requires some calculation, and then insert into another table. Both tables have the field as DECIMAL(10,2) to fix the FLOATing point issues as outlined in my previous post.
The following line of code will reproduce the issue without need for any tables
SELECT CAST(FORMAT(CEIL((2791/1.13) * 100)/100,2) AS DECIMAL(10,2));
Why does it not return this amount that the following line returns ??
SELECT FORMAT(CEIL((2791/1.13) * 100)/100,2);
Thanks in advance.