• dwain.c (1/15/2013)


    You might want to look into using the CROSS APPLY VALUES approach to UNPIVOT (see the first article in my signature links). I find it much more readable that multiple UNPIVOTs and it seems to perform better as well.

    Thanks for the extra tip.