怎么 weekday 函數也會出錯﹖
select S.ScheduleBeginTime,E.EmpCode,E.EmpName,C1.CourseName,C.ClassHours, WeekdayName(weekday(convert(char(10),a.ScheduleBeginTime,111))) as Courseweek,
V.Name , C.Classroom,
RequiredID = case I.Required
when 1 then ''
when 0 then '選修'
else ''
end
from TMC_Class C
inner join TMC_Session S on S.ClassID = C.ClassID
inner join TMC_Course C1 on C.CourseID= .CourseID
left join TM_IDP I on C.CourseID = I.CourseID
inner join TMC_Student S1 on S1.CourseID = C.CourseID
left join EMP_Employee E on E.EmpCode = S1.EmpCode
left join VWTM_Teacher V on V.EmpCode = E.EmpCode
where E.EmpCode = I.EmpCode and E.EmpCode in (select EmpCode from EMP_Employee where DeptCode in (select DeptCode from dbo.fxORG_GetOrgTreeBySupervisor ('20498439','1')))
select S.ScheduleBeginTime,E.EmpCode,E.EmpName,C1.CourseName,C.ClassHours, WeekdayName(weekday(convert(char(10),a.ScheduleBeginTime,111))) as Courseweek,
V.Name , C.Classroom,
RequiredID = case I.Required
when 1 then ''
when 0 then '選修'
else ''
end
from TMC_Class C
inner join TMC_Session S on S.ClassID = C.ClassID
inner join TMC_Course C1 on C.CourseID= .CourseID
left join TM_IDP I on C.CourseID = I.CourseID
inner join TMC_Student S1 on S1.CourseID = C.CourseID
left join EMP_Employee E on E.EmpCode = S1.EmpCode
left join VWTM_Teacher V on V.EmpCode = E.EmpCode
where E.EmpCode = I.EmpCode and E.EmpCode in (select EmpCode from EMP_Employee where DeptCode in (select DeptCode from dbo.fxORG_GetOrgTreeBySupervisor ('20498439','1')))
from TMC_Class C
inner join TMC_Session S on S.ClassID = C.ClassID
inner join TMC_Course C1 on C1.CourseID=C.CourseID
left join TM_IDP I on I.CourseID = C.CourseID
inner join TMC_Student S1 on S1.CourseID = C.CourseID
left join EMP_Employee E on E.EmpCode = S1.EmpCode
left join VWTM_Teacher V on V.EmpCode = E.EmpCode
用到了CourceID字段的表有:TMC_Class、TMC_Cource、TMC_Student
用到了EmpCode字段的表有EMP_Employee、TMC_Student、VWTM_Teacher
那么你能保证上面的表中确实存在这样的字段吗?