INSERT INTO ... SELECT fails

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  April 15, 2003 at 8:44 am

  #79839

  Greetings,

  can anybody explain to me why this query

  INSERT INTO tblhbest1(UnternehmenID, Handelsobjekt) SELECT UnternehmenID, Handelsobjekt FROM view1

  receives a

  Server: Msg 8623, Level 16, State 2, Line 1

  Interner Fehler des Abfrageprozessors: Der Abfrageprozessor konnte keinen Abfrageplan erzeugen. (I guess in English it's ...cannot create execution plan)

  Any help is appreciated!

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  April 15, 2003 at 11:11 am

  #454275

  This seems to me like a problem related to service pack

  Try the following link

  http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B235401

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  April 16, 2003 at 1:26 am

  #454327

  Hi,

  thanks for reply. I read the article, corrected the index on the table and it works.

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]