PIVOT does not work with materialized view refresh
We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL
Tag: pivot
Row transposition
Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as:
Learning is not a spectator sport 