Moving one column of data to new table in new DB

• Timothy Moore

  SSC Veteran

  Points: 264

  More actions

  January 22, 2007 at 12:13 pm

  #175538

  I have 1 column of data that i need to somehow get into a new column over in another table. Not sure on the syntax for the query on this. Any help? thanks

• jezemine

  SSCrazy Eights

  Points: 8059

  More actions

  January 22, 2007 at 5:37 pm

  #684823

  insert into MyDestination (MyCol)

  select MyCol from MySource

  ---------------------------------------
  elsasoft.org

• Tim Mitchell

  SSCoach

  Points: 15681

  More actions

  January 23, 2007 at 9:15 pm

  #685127

  If you're moving from one database to another, remember to qualify your identifiers:

  INSERT [db1].[dbo].[Table1] (my_column)

  SELECT my_column FROM [db2].[dbo].[Table2]

  Tim Mitchell, Microsoft Data Platform MVP
  Data Warehouse and ETL Consultant
  TimMitchell.net | @Tim_Mitchell | Tyleris.com
  ETL Best Practices