Convert和Datediff日期转换函数效率对比(第一次发帖)
<br />selecta.staffId,B.Name,<br />sum(caseday(a.ProduceDate)when'1' thena.complement+a.ProduceTimeelse 0 end)'1',<br />sum(caseday(a.ProduceDate)when'2' thena.complement+a.ProduceTimeelse 0 end)'2',<br />............<br />sum(caseday(a.ProduceDate)when'
原创
2011-03-09 10:33:00 ·
2742 阅读 ·
0 评论