I'm having some trouble coming up with a solution for this. In one of my procs I get a certain number. If this number is greater than 125000 I have to round to the nearest 5000. If it is less that 125000 I have to round to the nearest 2500. I'm pretty new to Sql Server so any help would be appreciated!