Timeline for Identifying rows which don't match a master row
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 18, 2012 at 20:41 | comment | added | Aaron Bertrand | +1 for both simplicity and performance (see the edit to my answer). | |
| Apr 18, 2012 at 19:28 | comment | added | Rachel |
@AaronBertrand I thought that too, but it sounds like this is some kind of maintenance script, or one-time thing, so copy/paste doesn't seem like a terrible option for that. Should be fairly quick to copy/paste the SELECT columns and do a Find/Replace or two on the comma to replace it with the join statement
|
|
| Apr 18, 2012 at 19:27 | comment | added | Aaron Bertrand |
I suspect the problem is there are a LOT of columns and Ben liked how much simpler EXCEPT made it seem.
|
|
| Apr 18, 2012 at 19:26 | history | answered | Rachel | CC BY-SA 3.0 |