what about

select Employeeid, effectivedate

          where effectivedt between  ....

union all

select employeeid , max(effectivedate)

from table

group by employeeid

having max(effectivedate) < fromdate

if you add the object event class

to the trace,

you can see creation and deletion of tables in tmpdb.

without executing [use tempdb]  

hope that helps

try

If Select ( isnumeric(@SPID)  ) = 0

     Begin

 PRINT 'Select all'

        select SPID, KPID, cpu, physical_io, cmd, nt_username, memusage, WAITTIME, LASTWAITTYPE, hostname, program_name, login_time,open_tran, status from sysprocesses

    ...

check the collation of the tempdb.