• 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 😀

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉