SELECT   checkinout.id as 序号 ,checkinout.pin as 打卡编号,userinfo.name  姓名, checkinout.checktime 签到时间,

    (case datepart(weekday, checktime)

    when 1  then '星期一'

    when 2  then '星期二'

    when 3  then '星期三'

    when 4  then '星期四'

    when 5  then '星期五'

    when 6  then '星期六'

    when 7 then '星期日'

    end) as 星期,

    (

    case checkinout.verifycode

    when '' then '指纹'

    when '' then '刷卡'

    else '其他'

    end

    )   as  打卡方式,

    (

    case sn_name

    when '' then '7号楼'

    when '' then '8号楼'

    when '' then '1号楼'

    when '' then '5号楼'

    end)   as '打卡地点'

    FROM [zkeco_db].[dbo].[checkinout],[zkeco_db].[dbo].[userinfo]

    where

    (

    [zkeco_db].[dbo].[userinfo].badgenumber=checkinout.pin)

    and

    [zkeco_db].[dbo].[checkinout].pin=''

    and

    checktime between  '2016/5/5 9:27:27' and '2016/5/5 9:27:27'

    order by id desc