Re: matrix transpose in SQL?

From: harakiri <vadic1_at_home.com>
Date: Sat, 28 Apr 2001 06:15:31 GMT
Message-ID: <7etG6.27329$Jh5.24585715@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 - 01:15:31 CDT