Transposing Rows Into Columns

Hello,

is there any quite easy solution for the problem of transposing the rows
into the columns? I have the following table with some data in it:

dealer date 09.00 10.00 11.00 12.00 13.00 14.00
-----------------------------------------------------------------
1 2004-10-01 1/1 2/3 3/3 3/4 4/5 0/3
1 2004-10-02 0/1 1/3 1/3 1/4 3/5 1/3

/and so on.../

I'd like to prepare a SELECT query in the stored procedure that will
display this data in the following form:

dealer date hour reservations
------------------------------------------------------------------
1 2004-10-01 09.00 1/1
1 2004-10-01 10.00 2/3
1 2004-10-01 11.00 3/3
1 2004-10-01 12.00 3/4
1 2004-10-01 13.00 4/5
1 2004-10-01 14.00 0/3
1 2004-10-02 09.00 0/1
1 2004-10-02 10.00 1/3
1 2004-10-02 11.00 1/3
1 2004-10-02 12.00 1/4
1 2004-10-02 13.00 3/5
1 2004-10-02 14.00 1/3

Is it possible to do it using some simple solution? I saw some possible
solutions but they are a bit confusing. Any ideas? Thanks in advance.

...:: fabio