Timeline for Query to Return Missing Data
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 11, 2019 at 5:27 | answer | added | Learning_DBAdmin | timeline score: 0 | |
| Nov 11, 2019 at 0:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 13, 2019 at 18:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 13, 2019 at 2:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 22, 2016 at 20:52 | comment | added | Randolph West | Excel problems are myriad. This could be a simple problem with the cell formatting in a certain row. Good luck! The UNION will solve this question's problem, as @Forrest suggested. | |
| Nov 22, 2016 at 19:54 | comment | added | BellHopByDayAmetuerCoderByNigh | @Forrest - Yes there are underlying problems. These were 2 Spreadsheets that were received and imported into SQL that should have been identical...but were not. | |
| Nov 22, 2016 at 19:53 | comment | added | Forrest | You can use UNION between your two select statements to answer the question you asked. However, certain issues you mention (near identical tables, missing entries) point to other underlying problems. | |
| Nov 22, 2016 at 19:50 | answer | added | datagod | timeline score: 1 | |
| Nov 22, 2016 at 19:43 | history | asked | BellHopByDayAmetuerCoderByNigh | CC BY-SA 3.0 |