Idle Spid Time

create table #sp_who2
( spid int
, Status varchar( 50)
, login varchar( 80)
, hostname varchar( 80)
, blkby varchar( 10)
, dbanme varchar( 80)
, command varchar( 500)
, cputime int
, diskio int
, lastbatch varchar( 22)
, programname varchar( 200)
, spid2 int
)
insert #sp_who2
exec sp_who2
select
spid
, datediff( ss, cast( 
substring( lastbatch, 1, 5) +
'/' + 
cast( datepart( year, getdate()) as char( 4)) +
' ' +
substring( lastbatch, 7, 20) as datetime)
, getdate() ) 'seconds'
 from #sp_who2
drop table #sp_who2