Keep Getting Errors Sql Server Msg 206 Level 16 State 2 Line 249 Operand Type Clash Int In Q37033629

I keep getting these errors on SQL server

Msg 206, Level 16, State 2, Line 249
Operand type clash: int is incompatible with date
Msg 8120, Level 16, State 1, Line 367
Column ‘EMPLOYEE.EmployeeFName’ is invalid in the select listbecause it is not contained in either an aggregate function or theGROUP BY clause.
Msg 8120, Level 16, State 1, Line 373
Column ‘RENTAL_OFFICE_LOCATION.RentalOfficeID’ is invalid in theselect list because it is not contained in either an aggregatefunction or the GROUP BY clause.
Msg 8120, Level 16, State 1, Line 378
Column ‘VEHICLE.Year’ is invalid in the select list because it isnot contained in either an aggregate function or

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.