Dear list,
To prevent a division by zero
i examine the divisor for zero.
INSERT INTO "TEMP"."TABLE2"
(COLUMN1)
SELECT
CASE
WHEN SOURCECOL = 0 THEN 0
WHEN SOURCECOL <> 0 THEN (Sum(SOURCECOL3/SOURCECOL))
END AS REAGENZ
FROM "TEMP"."TABLE1"
GROUP BY SOURCECOL;
Does not functioned for "Insert into ... ".
Is using the "case" statement in combination with "insert" possible ?
Best Regards,
Raik Thalheim
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
