update#Temp
setSQLBuffer =#Temp1.eventinfo
from#Temp,#Temp1
where#Temp1.id =@id
and#Temp.spid =@spid
select@spid=min(spid) from#Tempwherespid >@spid
end
insertintodc_block_info(batch_id,spid,status,SQLBuffer,hostname,BlkBy,BlockedSQLBuffer,LoginName,DBName,
CPUTime,DiskIO,LastBatch,program_name,Command)
SELECT@batch_id,convert(char(5),spid) SPID,CASElower(status) When'sleeping'Thenlower(status) Elseupper(status) ENDStatus
,SQLBuffer
, CASEhostname WhenNull Then' .'When' 'Then' .'Elsehostname ENDHostName
,CASEisnul |