Hi

Try this

select t1.userid,t2.testid,count(t2.questionid)

from #table1 t1

left join #table2 t2 on t1.testid = t2.testid

group by t2.testid,t1.userid

Hi

Try use this query:

select name from tempdb..sysobjects where name LIKE '#%'

This should select all temptables in the session.