Link to home
Create AccountLog in
Avatar of William White
William WhiteFlag for United States of America

asked on

query to count number of files loaded

I'm monitoring a system that is importing thousands of files an hour.  Each time a file is imported, a record is written into the database.  I want to write a query that will tell me how many files are imported each hour.  I would also like to know the average size of the files loaded each hour and possibly their average time to load.  I can get all my information from one table named 'loadtable' that has these columns;

LoadTableID, LoadDate, TimeToLoad, FileName,  ArchiveSize, SourceType, JobNumber, AppCode, ErrorCode, FtpWaitTime

What would be a good query for this?
ASKER CERTIFIED SOLUTION
Avatar of hanklm
hanklm

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account