How to get SQL Query Plan & SQL Text for statements which are executing

SQL Query 


SELECT getdate() as "RunTime", st.text as batch,

SUBSTRING(st.text,statement_start_offset / 2+1 ,

( (CASE WHEN a.statement_end_offset = -1

THEN (LEN(CONVERT(nvarchar(max),st.text)) * 2)

ELSE a.statement_end_offset END)  - a.statement_start_offset) / 2+1)  as current_statement

,qp.query_plan, a.* FROM sys.dm_exec_requests a CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) as st CROSS APPLY sys.dm_exec_query_plan(a.plan_handle) as qp

order by CPU_time desc