---1.当月每一天的汇总 SELECT SUM(Qty)Qty , DATEPART(DAY,pickDate) Pickday FROM dbo.Delivery WHERE DATEDIFF(MONTH, pickDate, GETDATE()) < 1 GROUP BY DATEPART(DAY, pickDate) ORDER BY pickday ----2.当天每一个小时的汇总 --通过系统函数获取24小时内的数据 select number INTO #NumInfo from master..spt_values where type='P' and number<24 SELECT b.number, ISNULL(temp.Qty,0)Qty FROM ( SELECT SUM(Qty)Qty , DATEPART(hour,pickDate) Pickday FROM dbo.Delivery WHERE DATEDIFF(DAY,pickDate,GETDATE())=0 GROUP BY DATEPART(hour,pickDate) ) temp RIGHT JOIN #NumInfo b ON temp.Pickday=b.number DROP TABLE #NumInfo