Re: More pain and sufferring with Tropashko's materialized path...
From: Robin Tucker <r.tucker_at_thermoteknix.com>
Date: Tue, 16 Sep 2003 11:33:43 +0100
Message-ID: <bk6os9$hrt$1$8302bc10_at_news.demon.co.uk>
Date: Tue, 16 Sep 2003 11:33:43 +0100
Message-ID: <bk6os9$hrt$1$8302bc10_at_news.demon.co.uk>
(apologies Celko, for the previous post to you personally, I hit the wrong button!)
The error is "Arithmetic overflow error converting expression to data type float". This, I assume, is for the POWER function. So even when I use BIGINT or DECIMAL(12,0), the problem is still there.
"--CELKO--" <joe.celko_at_northface.edu> wrote in message
news:a264e7ea.0309151428.4fa358d7_at_posting.google.com...
> >> When I execute this function with a number such as 113755/65536, I get
> arithmetic overflow. <<
>
> Have you tried DECIMAL(12,0) datatypes?
Received on Tue Sep 16 2003 - 12:33:43 CEST