asked on
I get a division by 0 error in SQL Server query
Hi,
I get a division by 0 error in my sql server query. How do I fix this error in my query?
Thanks in advance,
mrotor
I get a division by 0 error in my sql server query. How do I fix this error in my query?
Thanks in advance,
mrotor
Microsoft SQL ServerMicrosoft SQL Server 2008SQL
Last Comment
Dale Fye
what is the query?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@sdStuber
I guess, since I'm more familiar with Access, I prefer to test for a NULL or 0 as the denominator and set the result to NULL, before attempting the Division.
Yes, X/NULL = NULL, so it would not be averaged, but I guess from my perspective (still getting used to some of SQL Servers quirks), the case statement is more readable.
Dale
I guess, since I'm more familiar with Access, I prefer to test for a NULL or 0 as the denominator and set the result to NULL, before attempting the Division.
Yes, X/NULL = NULL, so it would not be averaged, but I guess from my perspective (still getting used to some of SQL Servers quirks), the case statement is more readable.
Dale