Hi,

I would be careful about making any form of 'X is faster than Y' statements , ever!

In this case i have found ,annecdotally, that PIVOT has a relatively high startup cost.

So, if you have a 'sparse' set of data if can be faster to use the cross tab, with more dense PIVOT. YMMV 🙂