員工排序依照-在職,離職-在職依(部門+員工編號),離職依(員工編號)

員工排序依照-在職,離職-在職依(部門+員工編號),離職依(員工編號)

select empid,empname,
istw=
Case DirOrUndir
when 0 then 0
else 1
End,
isout=
Case datepart(DAY,outdate)*0
When 0 Then 1
else 0 --no out
End,
unitid=
case datepart(DAY,outdate)*0
When 0 then '離職'
else unitid
End
from empbas
order by istw,isout,unitid,empid