SQL Server Group by date and by time of day over a date range, Sql Server

Language: Layout:

create table t ([userPingId] int, [createdAt] varchar(23), [lastUpdatedAt] varchar(23)) ; 
insert into t ([userPingId], [createdAt], [lastUpdatedAt]) values
 (1, '2017-10-17 11:31:52.160', '2017-10-18 14:31:52.160')
--,(2, '2017-10-18 00:00:00.000', '2017-10-18 00:00:00.000')
 
declare @s datetime = '2017-01-01', @e datetime = '2018-01-01';

;with n as (select n from (values(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) t(n))
, d as ( /* adhoc date/numbers table */
  select top (datediff(day, @s, @e)+1) 
      SessionDate=convert(datetime,dateadd(day,row_number() over(order by (select 1))-1,@s))
  from n as deka cross join n as hecto cross join n as kilo
                 cross join n as tenK cross join n as hundredK
   order by [SessionDate]
)
, h as ( /* add time ranges to date table */
  select 
      SessionDate
    , StartDateTime = dateadd(hour,v.s,SessionDate)
    , EndDateTime   = dateadd(hour,v.e,SessionDate)
    , v.point
  from d
    cross apply (values 
        (0,12,'morning')
       ,(12,17,'afternoon')
       ,(17,24,'evening')
      ) v (s,e,point)
)

select
    t.userPingId
  , h.SessionDate
  , morning = count(case when point = 'morning' then 1 end)
  , afternoon = count(case when point = 'afternoon' then 1 end)
  , evening = count(case when point = 'evening' then 1 end)
from t
  inner join h
    on t.lastupdatedat >= h.startdatetime
   and h.enddatetime   > t.createdat 
group by t.userPingId, h.SessionDate
--order by t.UserPingId, h.SessionDate

View schema
Execution time: 0,08 sec, rows selected: 4, rows affected: 2, absolute service time: 0,23 sec