Timeline for Convert Rows to columns using 'Pivot' in SQL Server when columns are string data type [duplicate]
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 16, 2017 at 20:44 | comment | added | Mohamed El-Qassas MVP | Check this social.technet.microsoft.com/wiki/contents/articles/… | |
| Sep 28, 2015 at 22:54 | history | closed | Paul White♦ | Duplicate of Dynamic pivot: sum of sales per month | |
| Sep 28, 2015 at 22:52 | history | edited | Paul White♦ |
edited tags
|
|
| Dec 5, 2012 at 21:55 | history | edited | marc_s | CC BY-SA 3.0 |
deleted 707 characters in body; edited title
|
| Jun 11, 2012 at 15:12 | comment | added | Jon of All Trades |
Note that you can always use, say, MIN() when you're pivoting without really aggregating. As long as there's just one value, MIN() or MAX() will work just as well. Also, it works for string values as described by your title (though contradicted by the body of your question!).
|
|
| Jun 11, 2012 at 11:22 | vote | accept | Sivajith | ||
| Jun 11, 2012 at 10:14 | answer | added | AmmarR | timeline score: 0 | |
| Jun 11, 2012 at 9:26 | answer | added | gbn | timeline score: 4 | |
| Jun 11, 2012 at 9:20 | history | asked | Sivajith | CC BY-SA 3.0 |