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 |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-04-17 : 21:24:14
|
| Syntax error converting the varchar value '1,876.43 ' to a column of data type int.i got this error im not really sure what its all about. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-17 : 21:27:57
|
| Well you can't have a comma in there. Plus you are going to lose the decimal places since int data type is just for whole numbers.Are you sure you don't want to use decimal data type instead?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-04-17 : 23:32:28
|
| thank you. i changed the datatype and its now running.. thanks again |
|
|
|
|
|
|
Syntax error