SQL Server View in progress

SELECT [Spid] = session_id, ecid, [Database] = db_name (sp.dbid),

[User] = Nt_username, [Status] = Er.status,

[Wait] = Wait_type,

[individual Query] = SUBSTRING (Qt.text, ER.STATEMENT_START_OFFSET/2, (case is Er.statement_end_offset =-1 Then LEN (C Onvert (NVARCHAR (MAX), Qt.text))

* 2 ELSE Er.statement_end_offset End-er.statement_start_offset)/2),

[Parent Query] = Qt.text,

program = Program_name, Hostname,

Nt_domain,getdate (), start_time

From

Sys.dm_exec_requests er INNER JOIN sys.sysprocesses sp on er.session_id = Sp.spid

Cross APPLY Sys.dm_exec_sql_text (er.sql_handle) as Qt

WHERE session_id >/* Ignore system spids.*/and session_id not in (@ @SPID)

ORDER BY start_time ASC

SQL Server View in progress