Archive for

Computed Columns and Divide by Zero Errors

Lets say you have a query, computed column etc. that has the following formula: SomeColumnA / SomeColumnB, where SomeColumnA and SomeColumnB are non-NULL numeric columns.  Clearly a problem can arise if there is a record in the database with SomeColumnB equal to 0.0, as that will result in a Divide by zero error. Thankfully there … Continue reading