Don Halloran (9/18/2013)
select ceiling(floor(@somevalue) / 5.0) * 5.0
A MUCH better solution!
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/