RadGrid datasource includes temp table

[Michael]

I have a query that I am putting some data in a temp table then retrieving it through another query.  The query works fine in my database editor, but then I run the same code on my site I get an error that table tblTemp doesn't exist.  Does the ASP.NET SQLDatasoure support these types of actions?  I am using the same account in the DB editor and the website.

select  idRecord.id
from    idRecord
where   id = 123456
into temp tblTemp;

select   profileRecord.username
from     profileRecord
where    id in (select id from tbltemp)