Home Forums SQL Server 2005 SQL Server 2005 General Discussion The query processor could not produce a query plan because a worktable is required, and its minimum row size exceeds the maximum allowable of 8060 bytes. A typical reason why a worktable is required is a GROUP BY or ORDER BY clause in the query. If the query has a GROUP BY or ORDER BY clause, consid RE: The query processor could not produce a query plan because a worktable is required, and its minimum row size exceeds the maximum allowable of 8060 bytes. A typical reason why a worktable is required is a GROUP BY or ORDER BY clause in the query. If the query has a GROUP BY or ORDER BY clause, co

  • June 23, 2014 at 5:20 am

    #1724014

    I have a report (SP) on global views that union 10 companies.

    Now I took the monthly backups of these companies and try the same on the last 6 month.

    So each view has about 60 'UNION ALL' from the different databases.

    And get the above error.

    I rebuilt the views for two month, the error is gone.

    Now I set the views back to 6 month, and split the major query in the SP, running seperatly each select. No error.

    It seems it doesn't matter where you split the query, just let it produce two execution plans.

    For me it was simple to do two Insert into #TmpTable.