Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JustinM
Starting Member
17 Posts |
 Posted - 2011-04-14 : 17:48:20
|
| I am multipying columns together and rounding to the nearest .01 using round(column1 * column2, 2). I would like to round to the nearest .02 instead. How can I do this? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-14 : 17:58:18
|
| SELECT ROUND(ROUND(column1 * column2 * 50, 0) / 50, 2) |
 |
|
|
JustinM
Starting Member
17 Posts |
Posted - 2011-04-14 : 19:15:44
|
| That'll work!Thanks! |
|
|
|
|
|
|
Round Function