Half hour incremental report Stored procedure

[HebieBug]

Would anyone have some code to pull a datetime field into half an hour alotments.
Am after a count for how many phone calls we recieve every half and hour.

 

[db999]

Is this what you need?

SELECT
count(datefld) TotalCol,
datepart(hh, datefld) HourCol,
datepart(n, datefld) /30 MinCol
FROM
tablename
GROUP BY
datepart(hh, datefld),
datepart(n, datefld) /30

ORDER BY
datepart(hh, datefld),
datepart(n, datefld) /30