How is division by 0 handeled in a computed select statement. I have tried a case stmt. without luck.
Here is an example of what I'm trying to accomplish:
SELECT
d.first_name,
d.last_name,
r.Store_Id,
r.LMLY,
r.Gallons_1mo,
--(r.Gallons_1mo / r.LMLY)-1 as MOM_Change_Per
FROM .....
Thanks a million if anyone has a suggestion!
andremc
Here is an example of what I'm trying to accomplish:
SELECT
d.first_name,
d.last_name,
r.Store_Id,
r.LMLY,
r.Gallons_1mo,
--(r.Gallons_1mo / r.LMLY)-1 as MOM_Change_Per
FROM .....
Thanks a million if anyone has a suggestion!
andremc