select ownerId, ownerType, scriptName, cleanQueryString, reportDate, hourOfDay, requestMethod, min( requestTimeMs ) minTimeMs, max( requestTimeMs ) maxTimeMs, avg( requestTimeMs ) avgTimeMs, count(*) transactions, count( distinct userId ) users from( select a.ownerId, a.ownerType, a.requestMethod, convert( datetime, convert( varchar, a.transactionDate, 1 )) reportDate, datepart( hour, a.transactionDate ) hourOfDay, scriptName, cleanQueryString, requestTimeMs, userId from fslogging..tbl_STP_Activity a with (nolock) where a.requestTimeMs is not null and a.cleanQueryString is not null and datediff( day, a.transactionDate, getDate() ) = 0 ) x group by x.reportDate, x.hourOfDay, x.ownerId, x.ownerType, x.scriptName, x.cleanQueryString, x.requestMethod order by reportDate, hourOfDay, ownerType, ownerId, requestMethod, scriptName, cleanQueryString update tbl_STP_ActivitySummary set minTimeMs = , maxTimeMs = , avgTimeMs = , transactions = , users = where reportDate = and hourOfDay = and ownerType = and ownerId = and requestMethod = and scriptName = and cleanQueryString = insert into tbl_STP_ActivitySummary ( reportDate, hourOfDay, ownerType, ownerId, requestMethod, scriptName, cleanQueryString, minTimeMs, maxTimeMs, avgTimeMs, transactions, users ) values ( , , , , , , , , , , , ) select ownerId, ownerType, reportDate, hourOfDay,min( requestTimeMs ) minTimeMs, max( requestTimeMs ) maxTimeMs, avg( requestTimeMs ) avgTimeMs, count(*) transactions, count( distinct userId ) users from( select a.ownerId, a.ownerType, a.requestMethod, convert( datetime, convert( varchar, a.transactionDate, 1 )) reportDate, datepart( hour, a.transactionDate ) hourOfDay, scriptName, cleanQueryString, requestTimeMs, userId from fslogging..tbl_STP_Activity a with (nolock) where a.requestTimeMs is not null and a.cleanQueryString is not null ) x group by x.reportDate, x.hourOfDay, x.ownerId, x.ownerType order by reportDate, hourOfDay, ownerType, ownerId update tbl_STP_ActivitySummary set minTimeMs = , maxTimeMs = , avgTimeMs = , transactions = , users = where reportDate = and hourOfDay = and ownerType = and ownerId = and requestMethod = '' and scriptName = '' and cleanQueryString = '' insert into tbl_STP_ActivitySummary ( reportDate, hourOfDay, ownerType, ownerId, requestMethod, scriptName, cleanQueryString, minTimeMs, maxTimeMs, avgTimeMs, transactions, users ) values ( , , , , '', '', '', , , , , )