• + 1 comment

    Hello,

    I have never done a pivot table before this challenge and couldn't find any great tutorials or examples. Would you mind clarifying what its doing?

    To me it looks like: - You set an int variable for each column (which represents each row) -I don't understand your select min statement -The from sets up a temporary table? -You then compare the select value to the case statement and add 1 to the respective column (to move the row value up) -I don't understand the second case statements purpose.

    Really cool stuff, trying to wrap my head around this.

    Thanks for your time :)