|
Shivas Irons
Starting Member
Canada
1 Posts |
 Posted - 11/11/2002 : 17:44:01
|
I have a table with transactional data in it. Each row represents one transaction and has a field (dCreated) which identifies when it was created.
With the following syntax I can count how many transactions occurred per minute:
SELECT COUNT(*) AS [count],
DAY(dCreated) AS d,
{ fn HOUR(dCreated) } AS h,
{ fn MINUTE(dCreated) } AS m
FROM tblAuditUploadAppProfile
GROUP BY DAY(dCreated), { fn HOUR(dCreated) }, { fn MINUTE(dCreated) }
ORDER BY DAY(dCreated), { fn HOUR(dCreated) }, { fn MINUTE(dCreated) }
But if a minute passes with no transactions it doesn't show up here. How do I 'show the zeros'?
Thanks,
Cam |
|
Counting zeros
