Michael Poppers (8/24/2010)
paul.knibbs (8/24/2010)
Didn't know ROUND() could do this, but once I looked it up in Books Online it seemed fairly straightforward--I learned something today, which is always nice!Get ready for a future QotD involving the opt. 3rd param. to ROUND() (oops, I gave it away :-)).
Nope, I already did that last week! http://www.sqlservercentral.com/questions/T-SQL/70325/[/url]
The good news for Michael is that this was the last question I submitted about ROUND().
The bad news is that I still have two other questions scheduled for the next two tuesdays.:-P