Timeline for Identifying rows which don't match a master row
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 6, 2018 at 16:03 | history | edited | MDCCL |
Generic tag of the DBMS at issue. Recent [except] tag.
|
|
| Apr 22, 2012 at 23:09 | history | tweeted | twitter.com/#!/StackDBAs/status/194201408843694080 | ||
| Apr 19, 2012 at 13:10 | history | edited | Zelda | CC BY-SA 3.0 |
edited title
|
| Apr 19, 2012 at 13:01 | vote | accept | Zelda | ||
| Apr 18, 2012 at 22:04 | comment | added | Aaron Bertrand | You'll also want to consider whether any of the columns are NULLable. This can affect how you do your comparisons (ideally the columns will all be defined as NOT NULL). | |
| Apr 18, 2012 at 21:53 | comment | added | Zelda | @AaronBertrand nvarchars and ints, with some odds and ends like datetimes. Could be anything, multiple tables actually. | |
| Apr 18, 2012 at 20:57 | comment | added | Aaron Bertrand |
Ben, data types of the settingx columns?
|
|
| Apr 18, 2012 at 19:36 | answer | added | Aaron Bertrand | timeline score: 4 | |
| Apr 18, 2012 at 19:26 | answer | added | Rachel | timeline score: 1 | |
| Apr 18, 2012 at 19:26 | answer | added | JNK | timeline score: 1 | |
| Apr 18, 2012 at 19:25 | history | edited | Zelda | CC BY-SA 3.0 |
added 259 characters in body
|
| Apr 18, 2012 at 19:15 | comment | added | Aaron Bertrand | Thanks, from this sample data, which rows do you want returned? They all seem to have the same settings, I assume you meant to show at least one row where at least one setting was different? | |
| Apr 18, 2012 at 19:11 | history | edited | Zelda | CC BY-SA 3.0 |
added 504 characters in body
|
| Apr 18, 2012 at 19:08 | comment | added | Aaron Bertrand | Still hard to visualize without sample data / desired results. | |
| Apr 18, 2012 at 18:47 | comment | added | Aaron Bertrand |
Can you show a few rows of sample data and your desired results from the query? Also can you explain what column(s) make up the key in each table? It may be that EXCEPT is not the syntactic sugar you want or need in this case.
|
|
| Apr 18, 2012 at 18:25 | history | asked | Zelda | CC BY-SA 3.0 |