Created On: 2/17/2004 5:09:00 PM SELECT CONVERT(varchar(8),Tra_Date,1) AS 'Day',
CASE WHEN DATEPART(hour,Tra_Date) = 7 THEN '7am-8'
WHEN DATEPART(hour,Tra_Date) = 8 THEN '8am-9'
WHEN DATEPART(hour,Tra_Date) = 9 THEN '9am-10'
WHEN DATEPART(hour,Tra_Date) = 10 THEN '10am-11'
WHEN DATEPART(hour,Tra_Date) = 11 THEN '11am-Noon'
WHEN DATEPART(hour,Tra_Date) = 12 THEN 'Noon-1'
WHEN DATEPART(hour,Tra_Date) = 13 THEN '1pm-2'
WHEN DATEPART(hour,Tra_Date) = 14 THEN '2pm-3'
WHEN DATEPART(hour,Tra_Date) = 15 THEN '3pm-4'
WHEN DATEPART(hour,Tra_Date) = 16 THEN '4pm-5'
WHEN DATEPART(hour,Tra_Date) = 17 THEN '5pm-6' END AS TranHour,
COUNT(*) AS TranCount
FROM Transactions
GROUP BY CONVERT(varchar(8),Tra_Date,1),DATEPART(hh,Tra_Date)
ORDER BY CONVERT(varchar(8),Tra_Date,1)
|
