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 |
|
Mazdak
Yak Posting Veteran
63 Posts |
 Posted - 2008-06-18 : 06:42:37
|
| I have a money field, which I want to Round price in it to nearest .95 cent . The problem I have is, I don't know how to give 0.95 to Round function.ThanksMazdak |
|
|
bjoerns
Posting Yak Master
154 Posts |
Posted - 2008-06-18 : 07:09:04
|
| Round (price + 0.05) to the nearest int and substract 0.05?(54224 row(s) affected)The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. |
 |
|
|
|
|
|
Round Function