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 |
|
sameerv
Starting Member
29 Posts |
 Posted - 2003-11-06 : 09:13:30
|
| I need help on a query to do the following:I have a table with the following structureTable 1ru_proj_id varchar 6ru_resource_cat varchar 10ru_resource_id varchar 10ru_role varchar 50ru_joindate Datetimeru_estimate_releasedate Datetime I have another table, Table 2 having the identical structure.None of the 2 tables have a primary key.I need to compare the data in the 2 tables.For each record, if the value in any column in Table 1 differs from the column value of the corresponding record in Table 2, the record in Table 1 should be updated with the value of Table 2.If it is not possible to update in a single query, even a SELECT query that returns the mismatched records would help.Cursors - A curse |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-11-06 : 09:43:53
|
| Not having a primary key makes this impossible as there is no way to determine the "corresponding record" ...Jay White{0} |
 |
|
|
|
|
|
Update Query