INSERT INTO table using OpenQuery

• guerillaunit

  SSCarpal Tunnel

  Points: 4249

  More actions

  August 13, 2012 at 2:47 pm

  #260687

  Hi, I currently use the following to data warehouse a table everday:

  DROP TABLE mytable

  SELECT firstcolumn, secondcolumn INTO mytable

  FROM OPENQUERY (mylinkedserver, 'SELECT firstcolumn, secondcolumn FROM linkedtable')

  I would like to start using TRUNCATE going forward (to perserve system resources and indexes):

  TRUNCATE TABLE mytable

  INSERT INTO mytable (firstcolumn, secondcolumn)

  ?

  How do I use OpenQuery with the INSERT INTO statement?

• Jared

  SSC Guru

  Points: 61793

  More actions

  August 13, 2012 at 3:00 pm

  #1525297

  TRUNCATE TABLE mytable

  INSERT INTO mytable (firstcolumn, secondcolumn)

  SELECT firstcolumn, secondcolumn

  FROM OPENQUERY (mylinkedserver, 'SELECT firstcolumn, secondcolumn FROM linkedtable')

  Jared
  CE - Microsoft