Question Re: SQL PIVOT? in Technology Q&A

SQL PIVOT?

Former Member — Thu, 27 Nov 2014 13:54:57 GMT

I have a sql that return these columns.

Material---Description---Price---Type
-------------------------------------
Test1--------Desc1--------21----Ak1--
Test1--------Desc1--------29----Ak2--
Test1--------Desc1--------31----Ak3--
Test1--------Desc1--------41----Ak4--
Test2--------Desc2--------12----Ak1--
Test2--------Desc2--------22----Ak2--
Test2--------Desc2--------31----Ak3--
Test2--------Desc2--------51----Ak4--


My question is, if it can take values from a colum and make these values to new columns and take a value from a second column to these new columns. Values for the new columns are price column. Like this:
Material---Description---Ak1---Ak2---Ak3---Ak4
----------------------------------------------
Test1--------Desc1-------21----29----31----41-
Test2--------Desc2-------12----22----31----51-

Re: SQL PIVOT?

Breck_Carter — Thu, 27 Nov 2014 15:27:43 GMT

Have a look at SQL Anywhere 17's PIVOT feature.

Alternatively, try this: Crosstab, Rotate, Pivot

Re: SQL PIVOT?

VolkerBarth — Thu, 27 Nov 2014 17:52:29 GMT

Version 17?

Man, I seem to have missed something by not having taken part in the current summit:)

Re: SQL PIVOT?

VolkerBarth — Thu, 27 Nov 2014 17:55:43 GMT

As you have yourself used the "pivot" tag, just have a look at the other FAQs with that same tag...

Re: SQL PIVOT?

Vlad — Fri, 28 Nov 2014 04:59:02 GMT

Agree :), me too. I have heard about v17. But not much.

Re: SQL PIVOT?

Breck_Carter — Fri, 28 Nov 2014 07:38:13 GMT

Yes, there is much that is cool coming in 17... there may even be room for a "Top 17 Cool New Features" article 🙂

Re: SQL PIVOT?

Former Member — Fri, 28 Nov 2014 12:42:39 GMT

when will version 17 be released, is there somewhere you can read about the new features?

Re: SQL PIVOT?

Breck_Carter — Fri, 28 Nov 2014 15:07:19 GMT

SQL Anywhere 17 may be feature-complete at the end of 2014 and released in the third quarter of 2015.

No mention has been made of a beta, and if recent history (Raspberry Pi)

is any indication,
"SAP don't have to show you any stinking beta!"