I have been trying to figure out the right way to do this. Any help is appreciated even just a pointer to a SQL concept I am lacking. I've looked at examples of using PIVOT but I am have been at a loss on using the aggregate function needed since I need to retain my values and set them to static named columns.
Asked
Active
Viewed 19 times
0
Chris Albert
- 2,406
- 7
- 27
- 30
DrewSKarn
- 1
- 1
-
Google sql server PIVOT. – jarlh May 14 '20 at 19:36
-
SQL server 2016+ you might also look into string_agg. – avery_larry May 14 '20 at 19:38