Timeline for Rows to Columns (SQL Server)
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 20, 2017 at 18:29 | vote | accept | Rafael Lima | ||
| Jun 20, 2017 at 18:29 | vote | accept | Rafael Lima | ||
| Jun 20, 2017 at 18:29 | |||||
| Jun 20, 2017 at 18:17 | comment | added | Jacob H | @ScottHodgin that was my question when this question was asked (then deleted and re-created I believe?). Also, what if there's no matching debit to a credit? Is it assumed that the phantom row is = 0? | |
| Jun 20, 2017 at 17:56 | vote | accept | Rafael Lima | ||
| Jun 20, 2017 at 18:29 | |||||
| Jun 20, 2017 at 17:53 | answer | added | Arulkumar | timeline score: 0 | |
| Jun 20, 2017 at 17:43 | answer | added | Taryn | timeline score: 5 | |
| Jun 20, 2017 at 17:37 | comment | added | Scott Hodgin - Retired | How do you think Sql server will know the first two rows go together without a column to designate some kind of order to the rows. Even if you inserted a credit, then a debit, then a credit, then a debit, there is no way to guarantee the rows will be selected in that order. You have to have a way to associate debits and credits. | |
| Jun 20, 2017 at 17:15 | history | asked | Rafael Lima | CC BY-SA 3.0 |