Competetor

Competetor

  • 1.1k
  • 672
  • 36k

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

Dec 26 2017 6:39 AM
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. 

Answers (7)