I can't believe I am unable to think of a nice neat way to do this. Does anyone know of a way to limit a value to a specific decimal increment in MSSQL Server 2000? I have a trigger that calculates and saves a result upon insert and update. I want to apply a rule to the calculation that limits the multiplier to a multiple of a decimal value. This would be supplied
@Any_Val_1 * @Any_Val_2 = @Result_Val The increment needs to be variable depending on the situation. (Might be 0.25 at one time, 0.5 another. 1.0 is easy of course). How can I round up, or down, Any_Val_2 to enforce a rule that it must be evenly divisible by a specified decimal value? I am stumped. It's driving me crackers. I would really appeciate it if anyone has a good idea for this type of problem. Everything I can think of this morning looks like a gruesome, convoluted, resource-wasting case monster. Thanks Sue ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1704 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
