The multi-part identifier "E.EmployeeId" could not be bound.

Question

I have sql script as select E.EmployeeId E.Name A.FromDate A.SPDays from EEmployee E cross join [dbo].[GetAppointmentDateAndServicePeriodDays](E.EmployeeId) A where [dbo].[GetAppointmentDateAndServicePeriodDays] is a table valued function which returns FromDate SPDays. But I am getting error The multi-part identifier E.EmployeeId could not be bound. Can someone help me to correct this script? I would be grateful for any proper solution. Thank you.

Suresh Shewale · Answer

hi please change cross join as cross apply

Narayan Prasad Twayana · Answer

Thank you Suresh for your reply. GetAppointmentDateAndServicePeriodDays is a table valued function which has EmployeeId of datatype int as input parameter. It returns single row table with columns FromDate(DateTime) and SPDays(int).

Suresh Shewale · Answer

will you please give detail of [dbo].[GetAppointmentDateAndServicePeriodDays] so that we will help you?Table valued function ....

Narayan Prasad Twayana · Answer

Thank you Ankit for the reply. But I could not get proper solution from the provided links. Can someone point out where I am wrong?

Ankit Sharma · Answer

Hi Below links might be of your help https://stackoverflow.com/questions/7314134/the-multi-part-identifier-could-not-be-bound?rq=1 https://stackoverflow.com/questions/32894546/sql-multi-part-identifier-could-not-be-bound

Suresh Shewale · Answer

the error itself shows that employee table has not field EmployeeId.Check employeeid field name properly in that table.

Amit Kumar · Answer

Hi In your query U have define E.EmployeeId treated as A and you select E.EmployeeId correct it.