Post reply

Manipulate Horizontal Hierarchy with UNPIVOT

  • December 20, 2012 at 3:45 am

    #267924

    Comments posted to this topic are about the item Manipulate Horizontal Hierarchy with UNPIVOT

  • January 15, 2013 at 11:37 pm

    #1577652

    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.

    My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]

    My thought question: Have you ever been told that your query runs too fast?

    My advice:
    INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
    The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

    Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
    Since random numbers are too important to be left to chance, let's generate some![/url]
    Learn to understand recursive CTEs by example.[/url]
    [url url=http://www.sqlservercentral.com/articles/St

  • April 30, 2013 at 9:25 pm

    #1611453

    Thanks!, good stuff! I will practice your technic!

    Cheers!

  • May 3, 2016 at 7:01 am

    #1876210

    Thanks for the script.

  • May 3, 2016 at 7:01 am

    #1876211

    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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply