select 1 sortSection, convert( datetime, null ) epoc, count(*) eventCount, 0 maxPasses, -1 maxDelay, count( distinct ownerType + convert( varchar, ownerid )) clientCount, -1 maxProcessingTimeMs, -1 epocRunMs, -1 errorCount from tbl_SYS_Events with (nolock) where eventProcessed = 'N' and errorOccured = 'N' and eventName = and serverName <> 'FSEDEV03' and serverName = 'FSEDEV03' and ownerType = and ownerId = select top #url.epocs# 2 sortsection, epoc, count(*) eventCount, max( passCount ) maxPasses, max( datediff( millisecond, eventTime, processedTime ) - processingTimeMs ) maxDelay, count( distinct ownerType + convert( varchar, ownerid )) clientCount, max( processingTimeMs ) maxProcessingTimeMs , datediff( millisecond, epoc, max( processedTime )) epocRunMs, sum( case when x.errorOccured = 'Y' then 1 else 0 end ) errorCount from tbl_SYS_Events x with (nolock) where epoc is not null and eventName = and serverName <> 'FSEDEV03' and serverName = 'FSEDEV03' and ownerType = and ownerId = group by epoc order by epoc desc select sortsection, epoc, eventCount, maxPasses, maxDelay, clientCount, maxProcessingTimeMs , epocRunMs, errorCount from qmd_pending union select sortsection, epoc, eventCount, maxPasses, maxDelay, clientCount, maxProcessingTimeMs , epocRunMs, errorCount from qmd_processed order by sortSection, epoc desc

Epoc	Events	Passes	Max Delay	Clients	Max Run	Epoc Run	Errors
#lsdateformat( epoc, "MM/DD/YY")# #lstimeformat( epoc, "HH:MMT")#Queued	#lsnumberformat( eventCount )#	#lsnumberformat( maxpasses )#	#lsnumberformat( val( maxDelay ) / 1000.0 )#	#lsnumberformat( clientCount )#	#lsnumberformat( val( maxProcessingTimeMs ) / 1000.0 )#	#lsnumberformat( val( epocRunMs ) / 1000.0 )#	#lsnumberformat( errorCount )#