Hi,

Any and all help greatly appreciated!! :)

I've got two tables where I want to take data out of table1.columnA and place it into table2.columnB. The caveat to this is that table 2 already contains data and I want the column to be added where existing data sits linked by an ID column.

What would be the best way to achieve this in SQL Server?

Thanks,

Mosser212

The insert into statment will do what you need.

the UPDATE...FROM statement might give you more results. The syntax is a bit puzzling and I'm never quite sure if it will work, but it generally seems to.

I'm having a little trouble figuring out exactly what your tables would appear to be, but as I understand you, table1 has data in column a that you want to move to table2 column b and it sounds to me like a column 'ID' is the relationship between the two?

If that is the case, using Phil's suggestion, it would be someting like

update table2

set B = table1.A

from table2

inner join table1

on table1.ID = table2.ID

 

If I have misunderstood you, apologies.

here is the code that works  your colum names would differ

 

 

INSERT INTO dbo.mapentity (oldentityid) SELECT scode FROM dbo.property