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 : 23:31:41
|
| Error Converting data type nvarchar to numeric. Have any simple way just change the nvchar to numeric to display. Analy_code25 as commission contain data in below :----------------------------------------------------0blank record13250blank record999-------------------------------------------------My sql query : RTRIM(dbo.item.anly_code25) AS commission, CONVERT(int,dbo.trx_dat.item_qty) AS qty, CAST(CONVERT(numeric(36, 2),dbo.item.anly_code25) * dbo.trx_dat.item_qty AS numeric(36, 2)) AS total_commission, -------------------------------------------------Please direct edit my sql query . thanks |
|
|
mandm
Posting Yak Master
120 Posts |
|
|
|
|
|
error message