displaying data from a recordset-pivot table

[moley]

Hi,

I have a stored procedure which returns a recordset :

date type 8-8:30 8:30-9 9-9:30 etc 21:30-20
1/1/03 12 0 3 2 3
2/1/03 13 0 0 1 4

etc.

I created the time bands using select(case x between y as 8-8:30) in the stored procedure.

I now want to display the data in the following format

type
12
date timeband value
1/1/03 8-8:30 0
1/1/03 8:30-9 3
1/1/03 9-9:30 2
etc


any ideas??

Cheers

Moley