Querying SQL Server-executed SQL

SELECT TOP
--Creation time
Qs.creation_time,
--Query statements
SUBSTRING (St.text, (QS.STATEMENT_START_OFFSET/2) +1,
(Case Qs.statement_end_offset WHEN-1 then datalength (st.text)
ELSE qs.statement_end_offset End-qs.statement_start_offset)/2) + 1
) as Statement_text,
--Execute text
St.text,
--Execution Plan
Qs.total_worker_time,
Qs.last_worker_time,
Qs.max_worker_time,
Qs.min_worker_time
from
sys.dm_exec_query_stats QS
--Key words
Cross APPLY
sys.dm_exec_sql_text (qs.sql_handle) ST
WHERE
qs.creation_time between ' 2012-12-03 09:00:00 ' and ' 2012-12-03 11:00:00 '
--and st.text like '% '
ORDER by
qs.creation_time DESC

Querying SQL Server-executed SQL