/*
Field's order should not be changed!!!
*/
USE master
select * from (
	select spid, p.blocked, d.name, waittime, lastwaittype, waitresource, open_tran, p.status, 
		hostname, program_name, cmd, loginame, cpu, physical_io, memusage, last_batch,
		--case when p.blocked <> 0 OR b.blocked IS NOT NULL then (select text from sys.dm_exec_sql_text(sql_handle)) else '' end as sql
		(select text from sys.dm_exec_sql_text(sql_handle)) as sql
	from 
		master.dbo.sysprocesses p 
		left outer join master..sysdatabases d on d.dbid = p.dbid
		left outer join (select distinct blocked from master.dbo.sysprocesses) as b on b.blocked = p.spid
	) as A
<%FILTER_EXPRESSION%>
order by blocked, waittime