Help with Insert statement

• actinicblue

  Mr or Mrs. 500

  Points: 575

  More actions

  December 10, 2001 at 12:14 pm

  #78363

  This is driving me crazy and I can't figure out why I get this message:

  Server: Msg 213, Level 16, State 5, Line 6

  Insert Error: Column name or number of supplied values does not match table definition.

  From this query:

  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

  WHERE TABLE_NAME = 'Curl')

  DROP TABLE Curl

  Create table Curl (access_time datetime, duration int)

  INSERT INTO Curl

  SELECT access_time, duration

  From Connections

  Where duration > 1

  I know it is some syntactical little problem but I am stumped. I know it has to do with the select statement under the insert. Ever have one of those days:) Please help!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737971

  More actions

  December 10, 2001 at 12:17 pm

  #420947

  need a "go" before teh insert.

  Steve Jones

  steve@dkranch.net