Copy data from one column into another column

Question

I want to move data from Column Col11 of DB1.Table1 into Col555 of DB2.Table7, based on a certain condition. How do I do it ? Is there a statement like -

select Col11 from DB1.Table1
into Col555 of Db2.Table7
where Col11 = 'Important'

This would be like ETL inside SQL server. But, I'd rather not use an ETL tool for this. — Steam, Oct 18 '13 at 22:24

score 2 · Accepted Answer · edited May 23 '17 at 11:47

2

You don't need COPY or INSERT but UPDATE(using JOIN):

UPDATE [DB2].[Table7]
SET [Table7].[Col555] = [Table1].[Col11]
FROM [Table1] JOIN [Table7] ON -- add the base for the join here...
WHERE [Table1].[Coll] = 'Important'

See this post for more details: SQL update query using joins

edited May 23 '17 at 11:47

Community

1
1

answered Oct 18 '13 at 22:44

Yosi Dahari

6,794
5
24
44

Getting a linked server error. Because these databases are on two different servers. – Steam Oct 18 '13 at 22:59
There should be no problem doing cross servers join assuming you have a linked server which was configured correctly. what error? – Yosi Dahari Oct 18 '13 at 23:01
making a new post on that – Steam Oct 18 '13 at 23:05
Here is the error and post - http://stackoverflow.com/questions/19460381/sql-server-error-in-executing-query – Steam Oct 18 '13 at 23:09

DeanG · Answer 2 · 2013-10-18T22:36:13.577

0

INSERT INTO [DB2].[Table7] (Col555)
SELECT [Table1].[Col11]
FROM [DB1].[Table1]
WHERE [Table1].[Coll] = 'Important'

--May need .[dbo] or schema name between database and table names.

edited Oct 18 '13 at 22:36

answered Oct 18 '13 at 22:30

DeanG

617
4
6

score 0 · Answer 3 · answered Oct 18 '13 at 22:32

0

  INSERT INTO DB2.TABLE2(col555)
  SELECT Col11 FrOM DB1.TABLE1
  WHERE  Col11 = 'important'

answered Oct 18 '13 at 22:32

jcwrequests

1,132
1
7
13

Copy data from one column into another column

3 Answers3

Linked