1

Topic: PIVOT

The people, the guru ;-)
Saw enough read a material as in SQL to tear the table  horizontals.
Everywhere there is a link to a collection field in (' fld1 ', ' fld2 '.... ' fldn ')
But sometimes we do not know how many variants of columns it turns out. Whether there is a possibility to make request thus that to use technology dynamic ?
All thanks.

2

Re: PIVOT

Valerii wrote:

But sometimes we do not know how many variants of columns it turns out. Whether there is a possibility to make request thus that to use technology dynamic ?

Is not present. All in any way do not make :-(

3

Re: PIVOT

Valerii;
Such result can be received only by means of MDX from an OLAP-cube

4

Re: PIVOT

Transform look - http://www.sql.ru/faq/faq_topic.aspx?fid=571

5

Re: PIVOT

Kotsya wrote:

Transform look - http://www.sql.ru/faq/faq_topic.aspx?fid=571

the HARDWARE asked without it.

6

Re: PIVOT

a_voronin wrote:

Valerii;
Such result can be received only by means of MDX from an OLAP-cube

It is possible for a C ++.
At what here a sequel?

7

Re: PIVOT

alexeyvg wrote:

it is passed...
It is possible for a C ++.
At what here a sequel?

Well, not With ++, and is faster C#/VB.NET.
If does not want dynamic SQL, it is possible to write CLR function.

8

Re: PIVOT

alexeyvg wrote:

it is passed...
It is possible for a C ++.
At what here a sequel?

Well who than is engaged, about that and thinks first of all smile
I here during the first moment thought that to me PIVOT is rarely necessary, because I on columns will display the data already at report level in Matrix in Reporting'.

9

Re: PIVOT

tashkafox wrote:

it is passed...
Well who than is engaged, about that and thinks first of all smile
I here during the first moment thought that to me PIVOT is rarely necessary, because I on columns will display the data already at report level in Matrix in Reporting'.

Therefore probably also do not saw PIVOT since to twirl the data - the task nevertheless more client.