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 |
|
sankar4283
Starting Member
1 Post |
 Posted - 2011-08-16 : 02:23:02
|
| Please help me for the following scenario.I have 2 tables. 1. Table 1 with column 1 to column 102. Table 2 with column 1 to column 10By Comparing both tables i got more than 100 records difference. So i took each record (Row) from the difference by comparing all 10 columns one by one manually. Is there any way that i can compare and get the details quickly. E.g. Row 1 has the difference in column 7. (Instead checking all columns from the difference)Many thanks in advance for the help. Thanks,Sankar |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-08-16 : 02:36:52
|
no shortcut. you will need to compare it column by column
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Compare records in 2 tables issue