Timeline for Computing dates and counts
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 24, 2017 at 15:35 | answer | added | dnoeth | timeline score: 1 | |
| Jun 23, 2017 at 23:36 | history | edited | Jamal | CC BY-SA 3.0 |
added 36 characters in body; edited title
|
| Jun 23, 2017 at 15:31 | answer | added | coyote | timeline score: 2 | |
| S Jun 3, 2017 at 10:03 | history | bounty ended | CommunityBot | ||
| S Jun 3, 2017 at 10:03 | history | notice removed | CommunityBot | ||
| May 30, 2017 at 19:06 | comment | added | S3S | This is almost impossible to decipher--specifically that case statement. 99.9% sure it's easier done, and i can do it easier already with the test data but it's surely going to miss some logic. Can you explain logically why / how you determine what to calculate for the final column? | |
| May 27, 2017 at 4:18 | history | edited | Jamal | CC BY-SA 3.0 |
deleted 38 characters in body; edited title
|
| May 26, 2017 at 19:49 | history | edited | user3341592 | CC BY-SA 3.0 |
added 108 characters in body
|
| May 26, 2017 at 13:09 | comment | added | Adriano Repetti | Add that to your question, you will get much better and focused answers! There are some pretty smart "SQL guys" here. | |
| May 26, 2017 at 12:39 | comment | added | user3341592 | That seems like a very interesting tip. However, it seems that CTE are quite different (in syntax) in Oracle, and the code should, if possible, work on both SQL Server and Oracle. Thanks! | |
| May 26, 2017 at 10:20 | comment | added | Adriano Repetti | I'm not a SQL expert then I suppose you will get better answers but...did you first try to refactor that to use CTEs? | |
| S May 26, 2017 at 9:02 | history | bounty started | user3341592 | ||
| S May 26, 2017 at 9:02 | history | notice added | user3341592 | Draw attention | |
| May 25, 2017 at 18:56 | history | edited | user3341592 | CC BY-SA 3.0 |
edited body
|
| May 25, 2017 at 18:50 | history | edited | user3341592 | CC BY-SA 3.0 |
added 3 characters in body
|
| May 23, 2017 at 15:20 | comment | added | S3S | Any chance you can provide a small sample dataset and expected output? | |
| May 23, 2017 at 14:57 | history | asked | user3341592 | CC BY-SA 3.0 |