The query processor ran out of STACK SPACE

• Ranjith Nair-173567

  SSC Veteran

  Points: 209

  More actions

  October 14, 2004 at 11:08 pm

  #162393

  When I run a query with a few no of unions I see that it gives and error:

  Server: Msg 8621, Level 17, State 1, Line 1

  Internal Query Processor Error: The query processor ran out of stack space during query optimization.

  The query goes like this

   

  SELECT 1,171

  UNION

  SELECT 1,172

  UNION

  SELECT 1,173

  UNION

  SELECT 1,174

  and so on for some 1500 unions.

  Does anyone have a clue on this ?

   

  Thanks in advance for any reponses

   

• Guus Kramer

  Ten Centuries

  Points: 1031

  More actions

  October 22, 2004 at 1:44 am

  #527588

  why using 1500 unio's ??

  You can better create a temp table with two columns and fill this one up using a loop starting with 1,171 and ending with 1,1671 and query the values from the temp table.

  Just a thought..

  GKramer