Thanks for re-formatting the query - I'll see if I can get that fixed on the posted version of the script.

As far as Stored procs, it looks like you can do the same kind of thing as long as it's still in the cache, but not if the server has been restarted or the cache flushed since it was last run (much as with this script):

SELECT OBJECT_NAME(sys.dm_exec_sql_text.objectid),

sys.dm_exec_query_stats.*

FROM sys.dm_exec_query_stats

CROSS APPLY sys.dm_exec_sql_text (sys.dm_exec_query_stats.sql_handle)

WHERE sys.dm_exec_sql_text.dbid = db_id()

AND OBJECT_NAME(sys.dm_exec_sql_text.objectid) = 'yoursp'