SELECT req.[session_id] AS [SPID]
      ,req.status AS [Status]
      ,req.command AS [Command]
      ,DB_NAME( req.database_id ) AS [Database]
      ,CASE
         WHEN req.[statement_start_offset] > 0
         --The start of the active command is not at the beginning of the full command text
         THEN CASE req.[statement_end_offset]
                WHEN -1
                --The end of the full command is also the end of the active statement
                THEN SUBSTRING(sqltext.TEXT, (req.[statement_start_offset]/2) + 1, 2147483647)
                --The end of the active statement is not at the end of the full command
                ELSE SUBSTRING(sqltext.TEXT, (req.[statement_start_offset]/2) + 1, (req.[statement_end_offset] - req.[statement_start_offset])/2)
              END
         --1st part of full command is running
         ELSE CASE req.[statement_end_offset]
                WHEN -1
                --The end of the full command is also the end of the active statement
                THEN RTRIM(LTRIM(sqltext.[text]))
                --The end of the active statement is not at the end of the full command
                ELSE LEFT(sqltext.TEXT, (req.[statement_end_offset]/2) +1)
              END
       END AS [Current Statement]
      ,sqltext.[text] AS [Full Statement]
      ,req.cpu_time AS [CPU Time]
      ,req.total_elapsed_time AS [Elapsed Time]
  FROM sys.[dm_exec_requests] req
    CROSS APPLY sys.[dm_exec_sql_text](req.[sql_handle]) sqltext
  WHERE 1=1
        AND req.session_id > 50
        AND req.session_id <> @@SPID
        AND DB_NAME( req.database_id ) in ( 'my-db', 'tempdb' )
  ORDER BY req.[session_id], req.[request_id]