CODEWITHSUNDEEP
sql-server
Ben Carroll
Ben Carroll

Reputation: 73

Is there a data type in MsSQL bigger than float?

I am currently working with some ErlangC calculations to determine occupancy rates. I've got the functions I need working but when I start getting into higher numbers such as POWER(145,145), ~2.50242070x10^313, I get the following:

Arithmetic overflow error converting expression to data type float.

Is there anything in MsSQL I can use to handle these larger numbers? MS Excel can, but MsSQL can't?

Upvotes: 4

Views: 2919

Answers (1)

Frederico Almeida
Frederico Almeida

Reputation: 317

This is really hard. Not even Excel can handle this number. Excel can handle until 145^142 = 8.2084E+306. If you try 145^143 you will get an error. CLR data types also do not handle this number, so CLR Data Type is not an option.

As ErlangC calculations are done for traffic modeling, I would review your process to see if you are using the correct units on your formula (minutes, seconds, etc). This number is really really big to be achieved in a Call Center if this is your case.

Upvotes: 1

Related Questions