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 |
|
becky1
Starting Member
1 Post |
 Posted - 2007-07-04 : 19:19:11
|
| There is insufficient result space to convert a money value to smallmoney.It's a huge db with millions of records and we created asp files for it, and now my asp file will only works with smallmoney and not money data type.As with money data type i am getting error Microsoft VBScript runtime (0x800A000D)Type mismatch: 'CDbl'So i want to convert this field of MS SQL server db from "Money" to "SmallMoney" .But bec db has over million records and i am getting this error.There is insufficient result space to convert a money value to smallmoneyany way around it in SQL or in asp, i guess it's SQL problem so you guys must be expert on this. Help appreciated.thx |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 20:59:38
|
| Data range of smallmoney is - 214,748.3648 to 214,748.3647, the column may have value bigger than that. |
 |
|
|
facestheband
Starting Member
6 Posts |
Posted - 2007-07-05 : 00:25:53
|
| Is this actually representing money? if not, try a different data type, try numeric(16,2) (16 values, with 2 of them to the right of the decimal) |
|
|
|
|
|
|
insufficient result space to convert a money valu