Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Half hour incremental report Stored procedure
- Thread starter HebieBug
- Start date
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question
