select a.*,b.OutTime,b.InTime,convert(numeric(3,1),(datediff(minute,b.InTime,b.OutTime)-60)/60.0) as TotalTime
from BeProDailyReport as a
left join BM001Duty as b
on a.ReportDate=b.CheckDay and a.EmployeeID=b.EmployeeID
sql里面有没有判断的语句
类似于C#:
int a;
int b=a>9?a:9;
当b.InTime大于9点时,就返回B.InTime
当b.InTime小于等于于9点时,就返回9点
from BeProDailyReport as a
left join BM001Duty as b
on a.ReportDate=b.CheckDay and a.EmployeeID=b.EmployeeID
sql里面有没有判断的语句
类似于C#:
int a;
int b=a>9?a:9;
当b.InTime大于9点时,就返回B.InTime
当b.InTime小于等于于9点时,就返回9点
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货