Group By Day Name - And Time Range

Hi there,

With a DateStamp field

Im trying to group by Day Name

and also group it By Time ranges

i.e. Morning 00:00 to 11:59
Afternoon 12:00 to 17:59
Evening 18:00 to 23.59


I can do the group By Day Name ok
Like Below

Code:



SELECT COUNT(ISNULL(createdDate, 1)) AS DayCount, ISNULL(DATENAME(dw, createdDate), 'No Date Set') AS DayOftheWeek
FROM dbo.MyTable
GROUP BY ISNULL(DATENAME(dw, createdDate), 'No Date Set')




its just the grouping by time ranges im having trouble with..



Code:


M | T | W | Th | F | S | Su

Morning ||

Afternoon ||

Evening ||




Thanks for any help ..