Add data from columns C and D in Table 2 to colums A and B in Table 1

[cocopud]

We have 2 tables and want to copy/update the data from 2 columns in one table to the other table. One table has 4 columns (f_ident, f_type, s_ident and s_type). The information in columns s_ident and s_type needs to be added to the other table (over 45,000 rows). The other table also has s_ident and s_type columns that are currently empty. The criteria is that Table 1.f_ident = Table 2.f_ident and Table 1.f_type = Table 2._f_type then update the row with the new information.

Any suggestion on the best way to do this? I tried to do an Import Data, so I could create a dts package (will need to do this on another server as well); however, I can't figure out the exact sql statement to do this. Thanks.

 

[mrdenny]

A basic update statement is all that is needed.

update table2
   set table2.s_ident = table1.s_ident,
      table2.s_type = table1.s_type
from table1
where Table 1.f_ident = Table 2.f_ident 
   and Table 1.f_type = Table 2._f_type

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com