SELECT dbo.YGPBB.卡號, dbo.YGPBB.RQ AS 日期, dbo.KQSJB.SKQS AS 刷卡次數,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.BEG_SB,108) as datetime) AS 上班A,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.END_SB,108) as datetime) AS 下班A,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.BEG_SB2,108) as datetime) AS 上班B,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.END_SB2,108) as datetime) AS 下班B,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.BEG_SB3,108) as datetime) AS 上班C,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.END_SB3,108) as datetime) AS 下班C
FROM dbo.YGPBB INNER JOIN
dbo.KQSJB ON dbo.YGPBB.BQ = dbo.KQSJB.BQ AND dbo.KQSJB.BQ <> '99'
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.BEG_SB,108) as datetime) AS 上班A,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.END_SB,108) as datetime) AS 下班A,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.BEG_SB2,108) as datetime) AS 上班B,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.END_SB2,108) as datetime) AS 下班B,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.BEG_SB3,108) as datetime) AS 上班C,
cast(convert(char(11),YGPBB.RQ,120) +' '+ convert(char(8), dbo.KQSJB.END_SB3,108) as datetime) AS 下班C
FROM dbo.YGPBB INNER JOIN
dbo.KQSJB ON dbo.YGPBB.BQ = dbo.KQSJB.BQ AND dbo.KQSJB.BQ <> '99'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货