세콤 출근 / 퇴근 / 복귀 정보 출력하기
   
SELECT TOP 10  ATime,
                    Left(ATime,4) + '-'+ SUBSTRING(ATime,5,2) + '-'+ SUBSTRING(ATime,7,2) AS date  ,
                    SUBSTRING(ATime,9,2) + ':'+ SUBSTRING(ATime,11,2) + ':' + SUBSTRING(ATime,13,2) AS st , 
Flag1,
CASE Flag1

        WHEN '1' THEN '출근'
        WHEN '4' THEN '퇴근'
        ELSE '복귀'
END
,
Name

      from T_SECOM_ALARM 
WHERE 
      Left(CardNo,6) = '000000'
  AND 
                      (Left(ATime,8) = Convert(varchar(10),Getdate(),112)
        OR
        Left(ATime,8) = Convert(varchar(10),dateadd(d,-1,GETDATE()),112)
        OR
        Left(ATime,8) = Convert(varchar(10),dateadd(d,-2,GETDATE()),112)

      )
 
ORDER BY Atime DESC