Sean Lange (11/18/2013)
. . . While the pivot seems a bit contrived here it does a good job of demonstrating how it can be used. It seems to be difficult to find a usage for PIVOT when another methodology is unable to produce the same results more efficiently.
I am not sure what is your point, Sean.
Steve, thanks for an interesting QotD!