SQL Server Performance

Temp Table

Discussion in 'SQL Server Reporting Services' started by jastone, Aug 6, 2004.

  1. jastone New Member

    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
  2. scorpion509 New Member

    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.
  3. vaxman New Member

    Modify the query to:

    set fmtonly off;exec proc


Share This Page