SELECT
datepart(
hour
, JobComplete)
as
[
Hour
],
COUNT
(JobId)
[Jobs Completed]
FROM
dbo.Jobs
WHERE
JobComplete
between
@StartTime
and
@EndTime
GROUP
BY
;
With
cte
As
(
Select
DateAdd(
minute
, 15 * (DateDiff(
,
'20000101'
, SalesDateTime) / 15),
)
SalesDateTime,
SalesAmount
From
@Sales)
Cast
Avg
(SalesAmount)
decimal
(12,2))
AvgSalesAmount
Group
By
SalesDateTime;
Naomi N edited Revision 5. Comment: Added See Also
Naomi N edited Revision 4. Comment: Past tense
Naomi N edited Revision 3. Comment: Attempt to fix code blocks formatting
Richard Mueller edited Revision 2. Comment: Spelling
Naomi N edited Revision 1. Comment: Added toc
Naomi N edited Original. Comment: Minor grammar corrections
Strange, the code blocks now look bad
Hi,
For Quarter Hours, that should work too
SELECT DATEPART(minute, JobComplete)/15 AS [QuaterHour],
COUNT(JobId) AS [Jobs Completed]
FROM dbo.Jobs
WHERE JobComplete BETWEEN @StartTime AND @EndTime
GROUP BY DATEPART(minute, JobComplete)/15