Re: matrix transpose in SQL?
Date: Sat, 28 Apr 2001 06:15:31 GMT
Message-ID: <7etG6.27329$Jh5.24585715_at_news1.rdc1.sfba.home.com>
"Aakash Bordia" <a_bordia_at_hotmail.com> wrote in message
news:9ccmcp$fnq$1_at_stlnews.stl.ibm.com...
> Agreed, but if you could give me a practical example of such a situation,
> that would be super.
Nothing new here, you already mentioned it in your mail.
Source table:
date | traffic
1/1 | 12
1/2 | 55
...
2/1 | 34
...
is the representation that a sane database schema designer would choose over
some goofy schema like this:
Day | Jan | Feb | ...
1 | 12 | 55
2 | 34
(I understand, though, that this is report your customersw want:-) I agree, however, that transforming former into latter not much simpler task than transposing a matrix.... You'll have to resort to warehousing extensions ala "create dimension"... Received on Sat Apr 28 2001 - 08:15:31 CEST