Home Forums SQL Server 7,2000 General Trouble: Stored Procedure Taking Too Long RE: Trouble: Stored Procedure Taking Too Long

  • quote:


    Is the SQL built dynamically?


    I miss spoke above. In addition to passing the procedure dynamic global temp table names, I am also passing it various parameters for WHERE clauses.

    I replaced the dynamic global temp tables with static temp tables. did not help.