I want to know how many times each stored procedure gets executed for a given hour. I ran a trace using profiler template sqlprofilerSP_Counts and saved the trace results to a table, SP_COUNTS. I did a 'select distinct objectid from SP_COUNTS' to find the procs that were executed during the trace. How can I find out the number of times each was executed and store the sp_name and count in a table?