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

Competetor

8y3.3k

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suresh Shewale8y ago
hi please change cross join as cross apply
0
Competetor8y ago
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).
0
Suresh Shewale8y ago
will you please give detail of [dbo].[GetAppointmentDateAndServicePeriodDays] so that we will help you?Table valued function ....
0
Suresh Shewale8y ago
the error itself shows that employee table has not field EmployeeId.Check employeeid field name properly in that table.
-1
Competetor8y ago
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?
0
Amit Kumar8y ago
Hi, In your query U have define E.EmployeeId treated as A and you select E.EmployeeId correct it.
-1
Ankit Sharma8y ago
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
0