I don't understand why you need to craft a decimal this way. Why not just decide on the maximum precision and scale you need based on the expected data input and use that?
Is there a reason that the money or smallmoney datatypes aren't good enough for your purposes? Please correct me if I'm wrong, but the money datatypes are "fixed point" numbers out to 4 decimal places. Perhaps your "user defined precision" is a requirement to round to certain decimal places? This can be handled with most client side formatting.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply