SQL – rounding to nearest 5
Had a requirement to round some price values to the nearest £5 in a SQL stored proc. It’s easy to round to the nearest 10 using a negative value for the length parameter of the ROUND function i.e. returns 10 returns 20 but length must be of type tinyint, smallint, or int; so you can’t Read more about SQL – rounding to nearest 5[…]