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 |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2001-03-13 : 17:43:42
|
| I have a select statementSelect Sum(Power(2,@Variable)) as types Right now @variable is int .Previously i had values up to (@variable =30) only but now i have (@variable =31).It gives me this error.Arithmetic overflow error for type int, value = 2147483648.000000.In access the statement is like this and it does not give any errorSum(2^@Variable) AS Types |
|
|
|
|
|
Exponential problem