Home Forums SQL Server 2008 SQL Server 2008 - General Pivot Query RE: Pivot Query

  • December 31, 2012 at 10:07 am

    #1572541

    :O) (12/31/2012)

    If the point of PIVOT is to help turn row based values into column based values, how do I use it to produce the same results as the approach using the CASE statements?

    I'm just struggling to see the point of PIVOT - the syntax is absolutely horrible and confusing.

    I agree with you, I don't like the PIVOT clause either.

    This article can help you to clarify a little bit the differences between the two methods.Cross Tabs & PIVOT[/url]

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2