其他學生遲到及缺席問題!

55530645 · 2018-07-05

由於學生的遲到及缺席日數是有人手修訂的,所以websams系統的數字與成績表的數字是有出入的! 請問有沒有一條SQL或表格可找出那個全年總數目給班主任核對?

我發覺最接近的是 (學生缺席╱遲到╱早退清單 (R-ASR025-C)
但只能選T1,T2,T3, 並沒有總數的呢?

58019970 · 2018-07-09

老師請參考以下SQL語句:

select
a.schyear '學年',
a.CLASSCODE '班別',
a.CLASSNO '班號',
a.CHNAME '學生姓名(中)',
a.ENNAME '學生姓名(英)',
isnull(c1.LATEDAY,0) + isnull(c2.LATEDAY,0) + isnull(c3.LATEDAY,0) '全年遲到',
isnull(c1.ABSENTDAY,0) + isnull(c2.ABSENTDAY,0) + isnull(c3.ABSENTDAY,0) '全年缺席',
isnull(c1.EARLYLEAVEDAY,0) + isnull(c2.EARLYLEAVEDAY,0) + isnull(c3.EARLYLEAVEDAY,0) '全年早退'
from wsadmin.VW_STU_LATESTSTUDENT a
left outer join TB_ASR_STUDMISCDATA c1 on
a.SUID = c1.SUID and a.STUID = c1.STUID and a.SCHYEAR = c1.SCHYEAR and c1.TIMESEQ = 1100
left outer join TB_ASR_STUDMISCDATA c2 on
a.SUID = c2.SUID and a.STUID = c2.STUID and a.SCHYEAR = c2.SCHYEAR and c2.TIMESEQ = 1200
left outer join TB_ASR_STUDMISCDATA c3 on
a.SUID = c3.SUID and a.STUID = c3.STUID and a.SCHYEAR = c3.SCHYEAR and c3.TIMESEQ = 1300
where a.schyear = ? and a.classlvl=?
group by a.SCHYEAR, a.SUID, a.STUID, a.CLASSLVL, a.CLASSCODE, a.CLASSNO, a.SCHLVL, a.SCHSESS, a.CHNAME, a.ENNAME, c1.LATEDAY, c1.ABSENTDAY, c1.EARLYLEAVEDAY, c2.LATEDAY, c2.ABSENTDAY, c2.EARLYLEAVEDAY, c3.LATEDAY, c3.ABSENTDAY, c3.EARLYLEAVEDAY
order by a.CLASSLVL, a.CLASSCODE, a.CLASSNO
Click to expand...

教城討論區

其他學生遲到及缺席問題!

LOLO 220
Expand Collapse

edb-jackal
Expand Collapse

快捷搜尋

其他 學生遲到及缺席問題!

LOLO 220 Expand Collapse

edb-jackal Expand Collapse

其他學生遲到及缺席問題!

LOLO 220
Expand Collapse

edb-jackal
Expand Collapse