如果你:
最好给出完整的表结构,测试数据,计算方法和正确结果.发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281也许问题早几天就帮你解决了.
最好给出完整的表结构,测试数据,计算方法和正确结果.发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281也许问题早几天就帮你解决了.
datepart(dd,createtime) as dDate,
phonenumber,
case when datepart(dd,dateadd(hh,-9,createtime))%2 = 1 then sum(timelong) else 0 end) as oddDay,
case when datepart(dd,dateadd(hh,-9,createtime))%2 = 0 then sum(timelong) else 0 end) as evenDay
from 表名
group by datepart(d,createtime),phonenumber
order by datepart(d,createtime),phonenumber/*
sDate phonenumber oddDay evenDay
---------- ---------------- ----------- --------------
*/