Timeline for How to transpose rows into columns in SQL?
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S May 19, 2018 at 3:11 | history | suggested | colintobing | CC BY-SA 4.0 |
rename the title
|
| May 19, 2018 at 1:36 | history | tweeted | twitter.com/StackDBAs/status/997652173768003585 | ||
| May 18, 2018 at 22:06 | review | Suggested edits | |||
| S May 19, 2018 at 3:11 | |||||
| May 18, 2018 at 20:56 | answer | added | D_W | timeline score: 3 | |
| May 18, 2018 at 16:36 | comment | added | Rogelio Triviño | Maybe the others answers are the way to go if your situation, but don't forget that you work into a team. I propose more general and error prone solutions: 1 Ask programmers to do their job and provide queries adapted to your data model. 2 Ask your analyst to change the data model to adapt to real use cases modelling. | |
| May 18, 2018 at 15:32 | comment | added | ypercubeᵀᴹ | A worker has only 1 IN and 1 OUT? Or 1 IN and 1 OUT per day? | |
| May 18, 2018 at 15:17 | answer | added | paparazzo | timeline score: 2 | |
| May 18, 2018 at 14:31 | vote | accept | gerpaick | ||
| May 18, 2018 at 13:57 | comment | added | gerpaick | For example in 'User 4': there should be something like '---' | |
| May 18, 2018 at 13:57 | answer | added | Lennart - Slava Ukraini | timeline score: 7 | |
| May 18, 2018 at 13:56 | history | edited | MDCCL | CC BY-SA 4.0 |
Added the tag of the database management system of relevance. Modified formatting. Made some rewordings.
|
| May 18, 2018 at 13:53 | answer | added | James | timeline score: 2 | |
| May 18, 2018 at 13:46 | comment | added | McNets | What happens if there is only one IN or one OUT? | |
| May 18, 2018 at 13:45 | comment | added | gerpaick | no, a worker has only one IN and one OUT, if exists. It can be there is only IN, or OUT. But cannot have more than one. | |
| May 18, 2018 at 13:41 | comment | added | McNets | Can a worker has more than one IN or one OUT? | |
| May 18, 2018 at 13:38 | history | asked | gerpaick | CC BY-SA 4.0 |