dwain.c (8/6/2012)
SomewhereSomehow (8/3/2012)
When you asking about alternate solution you, do mean funtctional equivalent? you may use case+group by instead of pivot, and cross apply instead of unpivot. You may also check out these article about unpivot[/url].Wow! You quoted me!
Thanks for taking the time to read my article. I was wondering who that was. 😛
Wow!!....Don't forget me Dwain now that you have become all famous after writing that article.....lol 😀