SELECT
HIGHEST_CPU_QUERIES.PLAN_HANDLE,
HIGHEST_CPU_QUERIES.TOTAL_WORKER_TIME,
Q.DBID,
Q.OBJECTID,
Q.NUMBER,
Q.ENCRYPTED,
Q.[TEXT],max_WORKER_TIME,last_execution_time
FROM
(SELECT TOP 50
QS.PLAN_HANDLE,
QS.TOTAL_WORKER_TIME,
QS.execution_count,max_WORKER_TIME,last_execution_time
FROM
SYS.DM_EXEC_QUERY_STATS QS where datediff(d, last_execution_time,getdate())=0
ORDER BY QS.TOTAL_WORKER_TIME DESC) AS HIGHEST_CPU_QUERIES
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(PLAN_HANDLE) AS Q
ORDER BY HIGHEST_CPU_QUERIES.TOTAL_WORKER_TIME DESC