Timeline for Query to determine start and end dates based on time overlap
Current License: CC BY-SA 3.0
20 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Oct 20, 2016 at 12:07 | history | bounty ended | Paul White♦ | ||
| S Oct 20, 2016 at 12:07 | history | notice removed | Paul White♦ | ||
| Oct 19, 2016 at 21:40 | vote | accept | Noah Goodrich | ||
| Oct 18, 2016 at 17:02 | answer | added | Anthony Genovese | timeline score: 3 | |
| Oct 15, 2016 at 18:10 | comment | added | Rick James | Your first 3 examples can be encoded as "If an id is 'closed', then it is a group unto itself. Since that does not seem to highlight all your rules, please add more examples. | |
| Oct 13, 2016 at 9:33 | comment | added | Andrew Brennan | This would be easier with a schema change. There's no need for the two columns, closed and dead. Just have an "ended" column and then a reason for the ending. | |
| S Oct 13, 2016 at 5:23 | history | bounty started | Paul White♦ | ||
| S Oct 13, 2016 at 5:23 | history | notice added | Paul White♦ | Draw attention | |
| Oct 13, 2016 at 5:22 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Formatting
|
| Oct 13, 2016 at 2:56 | 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. | |
| Sep 12, 2016 at 10:54 | 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. | |
| Aug 12, 2016 at 14:23 | 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 12, 2016 at 16:47 | 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. | |
| May 30, 2016 at 18:36 | 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. | |
| Dec 15, 2015 at 21:19 | history | tweeted | twitter.com/StackDBAs/status/676874355884847104 | ||
| Jun 20, 2015 at 8:47 | history | edited | Noah Goodrich | CC BY-SA 3.0 |
Tried to clarify the rules for the groupings and offered a simplification
|
| Jun 20, 2015 at 7:08 | answer | added | Chris | timeline score: -2 | |
| Jun 20, 2015 at 3:34 | history | edited | Noah Goodrich | CC BY-SA 3.0 |
Added a gist for the dml and ddl statements to set up this data set locally.
|
| Jun 19, 2015 at 22:25 | history | edited | Noah Goodrich | CC BY-SA 3.0 |
fixed the list formatting
|
| Jun 19, 2015 at 22:19 | history | asked | Noah Goodrich | CC BY-SA 3.0 |