News for hackers. Stuff that matters.
Re:Pivot – Rows to Columns by sreaching on Monday February 05, 2018 @03:15PM (#16311702)
dynamic sql is the ugly solution - using a loop to generate the sql string to be executed.
Re:Pivot – Rows to Columns by fishcolorbrick on Monday February 05, 2018 @04:36PM (#16312436)
This is what I use at work. :) It can make the code difficult to read and update later though.