dwain.c (8/6/2012)

---

vinu512 (8/6/2012)

---

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 😀

How could I forget you Vinu, despite the fame and glory of being published! Now, all that awaits is the fortune coming my way and I'll be set. 😀