Post reply

Pivot Query

  • December 31, 2012 at 9:33 am

    #1572533

    I don't get it. What are your expected results?

    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

  • December 31, 2012 at 9:37 am

    #1572536

    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.

  • 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

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply