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 |
|
munishw
Starting Member
4 Posts |
 Posted - 2007-05-22 : 02:02:43
|
| Hi,I want to compare 2 tables row by row but without the use of cursors.LoopTable A.Col1 Compare to Table B.Col1 If Matched BreakEndI have tried couple of things like using min and currentid logicbut cant achieve what I want.Requesting if somebody guide me to the right way.Thanks. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-22 : 02:06:06
|
| If you are doing this in SQL 2005, you can simply use EXCEPT operator.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Comparing 2 tables row by row without cursors