阅读背景:

计数为零的所有月份的零值

来源:互联网 

This is my query:

这是我的查询:

SELECT STAFF.stf_first_name + '' + STAFF.stf_last_name As Name,
       DATENAME(month,RES_HAB_DATA.reshabdata_data_date) As Month,
       SUM(case when RES_HAB_DATA.reshabdata_duration > 0
                then (RES_HAB_DATA.reshabdata_duration/15) else 0 end) As ServiceDeliveryTime,
       MONTH(RES_HAB_DATA.reshabdata_data_date) As MonthNumber 
FROM RES_HAB_DATA
  JOIN RES_HAB ON RES_HAB_DATA.reshab_id = RES_HAB.reshab_id
  JOIN STAFF ON RES_HAB_DATA.staff_id = STAFF.stf_id
WHERE RES_HAB.serv_id = 30
  AND RES_HAB_DATA.reshabdata_data_date >= '1/1/2015'
GROUP BY STAFF.stf_last_name,
         STAFF.stf_first_name,
         DATENAME(month,RES_HAB_DATA.reshabdata_data_date),
         MONTH(RES_HAB_DATA.reshabdata_data_date)
ORDER BY MonthNumber
SELECT STAFF.stf_



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: