Hmm then not so sure why nothing comes out.

Try this one

------------------------------------------------------

--Get just one details from the spid (A)

------------------------------------------------------

SELECT r.session_id, r.status, r.start_time, r.command

FROM sys.dm_exec_requests r

------------------------------------------------------

--Get SPID then pass back FROM (A)

------------------------------------------------------

SELECT r.session_id, r.status, r.start_time, r.command, s.text

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s

WHERE r.session_id = '58'