create table #temp
(
spid smallint ,
ecid smallint ,
status nchar(30) ,
loginame nchar(128) ,
hostname nchar(128) ,
blk char(5) ,
dbname nchar(128) ,
cmd nchar(16),
request_id int
)
insert into #temp exec sp_who
select * from #temp where blk!=0 order by cast(blk as int) desc