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 |
|
sahu74
Posting Yak Master
100 Posts |
 Posted - 2004-03-05 : 16:10:44
|
I have a column C that need to be updated with the percent increase between column A and B as (A-B)/B. Also, if B=0 then I need to update the value in column C as 'NA'. If I am specifying Data type of column C as nvarchar to accomodate this, then I am having problem in updating the percent value. I keep getting the errorArithmetic overflow error for type varchar, value = -0.008854.The statement has been terminated. The data type of column A and B are decimal(14,2).Any suggestions?Thank you.PKS. |
|
|
sahu74
Posting Yak Master
100 Posts |
Posted - 2004-03-05 : 16:16:20
|
| Never mind. I figured it. Had field length too small.Thank you.PKS. |
 |
|
|
|
|
|
Is this possible?