This is a migrated thread and some comments may be shown as answers.

RadGrid datasource includes temp table

0 Answers 21 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Michael
Top achievements
Rank 1
Michael asked on 04 Feb 2011, 12:47 AM
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)

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Michael
Top achievements
Rank 1
Share this question
or