Home Forums SQL Server 2005 T-SQL (SS2K5) Division by zero on a SQL Instance while a different Instance run correctly RE: Division by zero on a SQL Instance while a different Instance run correctly

  • September 6, 2013 at 7:07 am

    #1648053

    btw, wouldn't it be better writing your example query more like :

    SELECT * FROM t

    WHERE (a<>0) and (b= 2 * a)

    ?

    It will avoid the "CASE" term