Cannot be bound error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

Cannot be bound error

Author

Topic

jwilson911
Starting Member

2 Posts

Posted - 2015-04-04 : 04:53:38

Hi.
I have this error. I've looked at other solutions posted here and I can't find my answer.
Ay help appreciated.

Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "ephd.DepartmentID" could not be bound.

USE AdventureWorks2012;
GO

SELECT TOP(10)
eph1.BusinessEntityID,
eph1.Rate,
epdh.DepartmentID,
RANK() OVER
(PARTITION BY ephd.DepartmentID ORDER BY eph1.Rate DESC) AS RankBySalary
FROM
HumanResources.EmployeePayHistory AS eph1
INNER JOIN
HumanResources.EmployeeDepartmentHistory AS epdh
ON eph1.BusinessEntityID = epdh.BusinessEntityID
WHERE
eph1.RateChangeDate =
(SELECT
MAX(RateChangeDate)
FROM
HumanResources.EmployeePayHistory AS eph2
WHERE
eph1.BusinessEntityID = eph2.BusinessEntityID)
ORDER BY
RankBySalary,eph1.BusinessEntityID;
go

JohnRWilson

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-04 : 07:57:31

Epdh <>epdh