Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jar
Starting Member
1 Post |
 Posted - 2006-12-16 : 13:42:10
|
| Table A200 Rows, each row: X, has a unique value. Has 2 extra columns: C1 and D1.Table B4000 Rows, each row: Z, has a value that corresponds to Table A's unique values. Has 2 extra columns: C2 and D2.What I am looking to do is update all 4000 rows in Table B to match the data set in Table A. C1 -> C2, D1 -> D2 following the criteria that X = Z.All the update attempts I've made so far only update 200 rows within Table B.Thank you for your help. |
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2006-12-17 : 12:16:32
|
| Hi,try thisUpdate TableB Set B.C2=A.C1,B.D2=A.D1 from TableA A inner Join TableB B on B.Z=A.XMadhu |
 |
|
|
|
|
|
Data Migration with Value Replacement