Oops. I should have said function, not formula. Thanks for your comment. I agree it would be simpler. That's why I mentioned the code could also be used in a function. Actually, my client already has a banker's rounding function. However, due to a permission problem my select (a query in...
I had a need to be able to calculate banker's rounding directly within a SQL SELECT statement. After searching here and elsewhere on the internet I could not find a solution. So I worked out how to do this and am posting my solution here for others who may have a similar need.
Banker's...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.