SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Bernabe Diaz / Manipulate Horizontal Hierarchy with UNPIVOT / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:31:02 GMT20RE: Manipulate Horizontal Hierarchy with UNPIVOThttp://www.sqlservercentral.com/Forums/Topic1398888-1509-1.aspxThanks!, good stuff! I will practice your technic!Cheers!Tue, 30 Apr 2013 21:25:06 GMTdiaz.bernabeRE: Manipulate Horizontal Hierarchy with UNPIVOThttp://www.sqlservercentral.com/Forums/Topic1398888-1509-1.aspxYou 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.Tue, 15 Jan 2013 23:37:42 GMTdwain.cManipulate Horizontal Hierarchy with UNPIVOThttp://www.sqlservercentral.com/Forums/Topic1398888-1509-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/SQL/95468/">Manipulate Horizontal Hierarchy with UNPIVOT</A>[/B]Thu, 20 Dec 2012 03:45:48 GMTdiaz.bernabe