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 |
|
usafelix
Posting Yak Master
165 Posts |
 Posted - 2015-01-01 : 22:46:53
|
| This SQL statement prompt error message is "Error Converting data type nvarchar to numeric". CAST(CONVERT(numeric(36, 2),dbo.item.anly_code25) * dbo.trx_dat.item_qty AS numeric(36, 2)) AS total_commissionItem.anly_code25 have some record is NULL and Blank ,thus prompt the error. if all record change to 0 to all numeric data is normal to run. |
|
|
mandm
Posting Yak Master
120 Posts |
|
|
|
|
|
converting data type nvarchar to numeric