sqlserver获取一段时间内每一天每一小时的数据

SELECT d,ISNULL(DRP, 0) AS DRP FROM(SELECT * FROM st_pptn_r_hourRIGHT JOIN (SELECTDATEADD(HH,number,'2017-06-13 00:00') AS dFROMmaster..spt_valuesWHEREtype = 'p'AND DATEDIFF(MI,DATEADD(HH,number,'2017-06-13 00:00'),'2017-06-17 00:00') > 0) t ON t.d = st_pptn_r_hour.TM)m