SQL PIVOT? 2000
Posted on 2015-02-17
WIth the below query we output data that is listed by inventory month then year. The end-user want to show this in columns not rows. That column will house the sales figures, and since they are already totaled I assume that this cannot be accomplished. Can anyone help? Crystal reports didn't like the amount of data being grouped so it errors out. I asked this question and accepted the solution (crystal reports) but it didn't work..