Home Forums SQL Server 2005 Development Divide by zero error encountered problem RE: Divide by zero error encountered problem
Dan Collier
SSC-Addicted
Points: 473
More actions
May 9, 2004 at 9:00 pm
#505741
This will give your desired reults without error.
Declare @Res int ,@denominator int
Set @Res = 0
Set @denominator = 0-0
Select @Res = CASE WHEN @denominator = 0 THEN 0 ELSE 5000/(@denominator) END
Select @Res as Result