Operand data type %1! is invalid for %2! operator.

Error Message:
Msg 8117, Level 16, State 1, Line 1
Operand data type %1! is invalid for %2! operator.

Severity level:

This error message appears when the datatype is not allowed for the chosen operator.

The T-SQL statement can be parsed, but causes the error at runtime.

Error of the Severity level 16 are generated by the user and can be fixed by the SQL Server user.

All versions of SQL Server.

USE Northwind
SELECT CustomerID, SUM(OrderDate)
  FROM dbo.Orders
 GROUP BY CustomerID

In the above example the error is raised, because the column OrderDate is of DATETIME datatype. As it makes logically very little sense to sum up values of that datatype in the SUM() aggregate function, the use of this operand is invalid for the SUM operator.


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |