Post reply

Arithmetic overflow error converting expression to data type int.

  • May 4, 2012 at 8:56 am

    #255443

    Hi, Okay so the sum of these values is greater than Max INT I tried to

    cast(sum(length) as bigint)

    But still no luck so how do I sum intergers when we know the sum will be bigger than MAXINT?

    Many thanks

  • May 4, 2012 at 9:02 am

    #1483624

    Edward-445599 (5/4/2012)

    Hi, Okay so the sum of these values is greater than Max INT I tried to

    cast(sum(length) as bigint)

    But still no luck so how do I sum intergers when we know the sum will be bigger than MAXINT?

    Many thanks

    Try:

    sum(cast(length as bigint))

  • May 8, 2012 at 2:57 am

    #1484379

    Ace thank you very much

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply