select
datename(dw,T.MY_DATETIME) as DayOfTheWeek,
T.MY_DATETIME,
datepart(hh,T.ACTLOG_DATETIME) as HourInterval
count(T.USER_IDENTIFIER) as UserCount
from log_hist T
Where
T.MY_DATETIME>convert(datetime,'10/22/2009') AND T.MY_DATETIME<convert(datetime, '11/30/2009')
group by
T.MY_DATETIME,
datename(dw,T.MY_DATETIME),
datepart(hh,T.ACTLOG_DATETIME)
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.