2 SQL Server 7.O error messages. - TechRepublic
General discussion
December 17, 2001 at 10:29 AM

2 SQL Server 7.O error messages.

Hi,

I’m trying to recreate an Access(.mdb) query in SQL and I’m getting the following error message in SQL: “Divide by 0 error encountered.” without any obvious reason. The same query works fine in Access.

Also when trying to use the aliases of the columns in a SQL query to create calculated columns in the same view, SQL wouldn’t let me do that. Any ideas?

Thanks,

Boris

This discussion is locked

All Comments