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?
Avatar of hanklm

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