hrvoje.piasevoli (8/23/2010)
Hi great qod!Here's a tip:
Move the decimal point to the left by the negative number and then do a regular ROUND(d, 0). Applied to this it ends looking like ROUND(0.1666666,0) and there you have it.
I wish I'd come up with it before I answered incorrectly 🙂
Regards,
Hrvoje Piasevoli
Thanks for the tip. It would have kept me from going 0 for 4 on these rounding questions. Sigh.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html