Timeline for Store Procedure, Group multiple tables by time interval to new table: daily run schedule
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 19, 2021 at 20:20 | vote | accept | Petter Östergren | ||
| Mar 18, 2021 at 21:36 | history | edited | Petter Östergren | CC BY-SA 4.0 |
minor code edit
|
| Mar 18, 2021 at 21:30 | history | edited | Petter Östergren | CC BY-SA 4.0 |
update current and desiered output
|
| Mar 18, 2021 at 21:25 | history | edited | Petter Östergren | CC BY-SA 4.0 |
update fiddle link
|
| Mar 18, 2021 at 21:16 | history | edited | Petter Östergren | CC BY-SA 4.0 |
grammar
|
| Mar 18, 2021 at 20:57 | history | edited | Petter Östergren | CC BY-SA 4.0 |
Added to the scope and proviede better tables.
|
| Mar 18, 2021 at 6:30 | comment | added | Petter Östergren | @J.D. I assume for now that would be the case yes, however it could be that a time-slot has 0 events. | |
| Mar 18, 2021 at 6:28 | comment | added | Petter Östergren | @McNets, I can understand this argument. Will look into adding some additional information. I do usually provide more details of what tests I’ll done so far, however my intention with this post was to figure out more resources that I could read up on. Im not sure what a table structure like this is called. Hence I was not able to elaborate in a better fashion. | |
| Mar 18, 2021 at 1:10 | answer | added | SMor | timeline score: 2 | |
| Mar 17, 2021 at 23:57 | review | Close votes | |||
| Apr 3, 2021 at 3:04 | |||||
| Mar 17, 2021 at 23:39 | comment | added | J.D. | Is it safe to assume your time range will always start and end at midnight? So if you want a half hour interval, the first interval is 2/28 at 12AM to 12:30AM, and the last interval will be from 11:30 PM to midnight? | |
| Mar 17, 2021 at 23:33 | comment | added | McNets | It would help if you add a create table and insert statements to your question. Have a look at How to create a Minimal, Complete, and Verifiable Example for database-related questions | |
| Mar 17, 2021 at 22:16 | review | First posts | |||
| Mar 18, 2021 at 0:26 | |||||
| Mar 17, 2021 at 22:12 | history | asked | Petter Östergren | CC BY-SA 4.0 |