could not generate a list of fields for the query. check the query syntax or click refresh fields on the query toolbar. invalid object name '#TEMP'. this is the error i am getting when i try to pull from a stored procedure with a temp table. is there a setting I can change to get RS to accept this temp table or should i change this temp table to a permanent table in SQL Server? Joe Janka
why don't you use stored procedure? or if you are working with SQL server 2000 use table as a variable. it will increase the performance too.
