select r.session_id, r.status, r.command
, r.blocking_session_id
, r.start_time, r.database_id, r.cpu_time

,   case when sql_handle IS NULL
                then ' '
                else ( substring(st.text,(r.statement_start_offset+2)/2,(case when r.statement_end_offset = -1        then len(convert(nvarchar(MAX),st.text))*2      else r.statement_end_offset    end - r.statement_start_offset) /2  ) )
        end as query_text 
--,st.text
,  object_name(st.objectid) 'proc'
,       st.dbid
,       st.objectid as object_id

from sys.dm_exec_requests  r
cross apply sys.dm_exec_sql_text(r.sql_handle) st
--where r.session_id > 50
order by 1