Re: Dynamic UNPIVOT using FOR XML and nodes()

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes, this is very cool technique! Thanks for sharing!

I have used similar method to get aggregates across columns:
http://pratchev.blogspot.com/2009/08/column-aggregates.html

The down side of those methods is performance....

Another similar query I posted earlier today:
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/c6bc463c-3c5d-4c14-bdf8-c043f69eb9f3

--
Plamen Ratchev
http://www.SQLStudio.com
.

Follow-Ups:
- Re: Dynamic UNPIVOT using FOR XML and nodes()
  - From: Farmer

References:
- Dynamic UNPIVOT using FOR XML and nodes()
  - From: Farmer

Relevant Pages

Re: Exhaust shittiness
... Using the patented Mavis Beacon "Hunt&Peck" Technique, Andy Bonwick typed ... We'll all be doing that in France. ... Who am i sharing with BTW? ...
(uk.rec.motorcycles)
Re: "Painting" embossed images with condensed milk
... That technique is gorgeous, thanks for sharing. ... happen if you put food coloring in the condensed milk. ...
(rec.crafts.rubberstamps)
Re: Electricity Samples and Tutorial is Posted Up Now
... Equinox, thanks for sharing the link. ... Here's another technique that uses 2 point poly chains for neon lights ...
(comp.graphics.apps.lightwave)
Re: DIY guide to making WH2O boulders
... at a fraction of the cost of a full set. ... Thanks for sharing! ... Cool technique and results look great. ...
(rec.games.pinball)