Timeline for SQL recursion and cte - dates timeseries
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 31, 2018 at 10:28 | answer | added | Marek Masko | timeline score: 1 | |
| Aug 31, 2018 at 9:32 | history | edited | John K. N. | CC BY-SA 4.0 |
swapped "this" for "statement"
|
| Aug 31, 2018 at 8:33 | answer | added | Lennart - Slava Ukraini | timeline score: 1 | |
| Aug 31, 2018 at 7:56 | history | edited | EzLo |
edited tags
|
|
| Aug 31, 2018 at 7:49 | answer | added | EzLo | timeline score: 2 | |
| S Aug 31, 2018 at 7:06 | history | edited | Tom V | CC BY-SA 4.0 |
Code formatting, some spelling, removing noise and added generic tag.
|
| Aug 31, 2018 at 7:01 | comment | added | Akina |
Why you do not use direct date-type in cte? select '2010-01-01' as start_date, '2010-01-01' as trial_date union all select start_date, dateadd(d, 1, trial_date) as trial_date from cte where trial_date <= '2010-01-10'?
|
|
| Aug 31, 2018 at 6:57 | review | Suggested edits | |||
| S Aug 31, 2018 at 7:06 | |||||
| Aug 31, 2018 at 6:49 | comment | added | Sabin B | Can you give some examples, to better understand your question ? A sample data and what is the desired output | |
| Aug 31, 2018 at 6:45 | review | First posts | |||
| Aug 31, 2018 at 9:32 | |||||
| Aug 31, 2018 at 6:44 | history | asked | serge | CC BY-SA 4.0 |