while@spidisnotnull
begin
set@c_SQL='dbcc inputbuffer('+convert(varchar(5), @spid) +')'
select@blocked=isnull(blocked,0) from#Tempwherespid=@spid
if(@blocked<>0)
begin
set@b_SQL='dbcc inputbuffer('+convert(varchar(5), @blocked) +')'
insertinto#Temp_b
exec(@b_SQL)
select@id=@@identity
update#Temp
setBlockedSQLBuffer =#Temp_b.eventinfo
from#Temp,#Temp_b
where#Temp_b.id =@id
and#Temp.blocked =@blocked
end
insertinto#Temp1
exec(@c_SQL)
select@id=@@identity
|