Information générale
Catégorie:
Codage, syntaxe et commandes
This is a puzzling problem. We have a select statement which includes various calculated columns. We are noticing that if the result of even one of the calculations is a division by zero, the entire record is dropped in the final result. Has anybody else run into this problem? Any insight would be helpful. We solved the problem by including iif's in the divisor protion of the calculations, but it sure is a pain in the you-know-what to do that.
Binoy W.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement