Home Forums SQL Server 2012 SQL 2012 - General Rounding a number up to the nearest 5 RE: Rounding a number up to the nearest 5
Don Halloran
SSCertifiable
Points: 5937
More actions
September 18, 2013 at 5:52 pm
#1651335
select ceiling(floor(@somevalue) / 5.0) * 5.0