• + 2 comments

    Help? MS SQL Server!

    SELECT A,B,C, CASE WHEN ((A = B) AND (B <> C) OR (B = C) AND (A <> B) OR (A = C) AND (A <> B)) THEN 'Isosceles' WHEN ((A = B) AND (B = C) AND (A = C)) THEN 'Equilateral' WHEN ((A <> B) AND (B <> C) AND (A <> C) AND NOT ((A + B) <= C) OR ((A + C) <= B) OR ((C + B) <= A)) THEN 'Scalene' WHEN (((A + B) <= C) OR ((A + C) <= B) OR ((C + B) <= A)) THEN 'Not A Triangle' END FROM TRIANGLES ORDER BY 1,2,3;