Insert into existing table from Query

• AVB

  SSChampion

  Points: 11418

  More actions

  January 23, 2007 at 3:07 pm

  #115421

  I created a table from a Select Into command.

  SELECT col1,col2,col3 INTO t_Table2 from t_Table1 where id > 23 and active = 1

  I'd now like to insert more values into this table from a similar select query. I know I can accomplish adding the data by Insert Exec with a SP or a Cusor but I'm trying to keep it simple. Out of all the things I've done in SQL I've never inserted data this way. Can it be done?  TIA.

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  January 23, 2007 at 3:10 pm

  #685075

  If the table is already created, the syntax is:

  INSERT INTO t_Table2

  SELECT col1,col2,col3

  FROM   t_Table1

  WHERE id > 23 and active = 1

• AVB

  SSChampion

  Points: 11418

  More actions

  January 24, 2007 at 6:00 am

  #685166

  Thanks much PW. It worked great.