A domain error occurred in SQL
-
Hi, I'm facing this problem which i don't know how to solve it. Can anyone guide me? I have a list of data in table @tmp1. Format like below. This table consists > 100 rows of data. Format: PartID PartNumber Yield 866 A100 0.98154735437972429 866 A100 0.9997734994337486 866 A100 0.99168797953964194 868 A200 0.70783730158730163 868 A200 0.99929971988795518 868 A200 0.99889908256880733 When i run this query, select partid,partnumber,convert(float,exp(sum(log(yield)))) from @tmp1 group by partid,partnumber Error encountered.Error message is "A domain error occurred". I'm trying to multiply all data from 'Yield' column. That's why i query with convert(float,exp(sum(log(yield)))) But I suspect convert(float,exp(sum(log(yield)))) is giving the error. So I tried to change datatype to int or varchar or decimal. But still cannot be solved. Pls help me. Thanks in advance.
-
Hi, I'm facing this problem which i don't know how to solve it. Can anyone guide me? I have a list of data in table @tmp1. Format like below. This table consists > 100 rows of data. Format: PartID PartNumber Yield 866 A100 0.98154735437972429 866 A100 0.9997734994337486 866 A100 0.99168797953964194 868 A200 0.70783730158730163 868 A200 0.99929971988795518 868 A200 0.99889908256880733 When i run this query, select partid,partnumber,convert(float,exp(sum(log(yield)))) from @tmp1 group by partid,partnumber Error encountered.Error message is "A domain error occurred". I'm trying to multiply all data from 'Yield' column. That's why i query with convert(float,exp(sum(log(yield)))) But I suspect convert(float,exp(sum(log(yield)))) is giving the error. So I tried to change datatype to int or varchar or decimal. But still cannot be solved. Pls help me. Thanks in advance.
-
Check whether column yield contains any -ve value this might result in domain error
Regards KP
It contains zero value. But don't have -ve value. How can i multiply all data when there is zero value? still convert(float,exp(sum(log(yield)))) ?? Can you please help to guide me? Thanks.