I have a problem with one of the ouputs from a table.

The table looks like this:

due_date events count(due_date)
4/5/2005 Affina 1
4/5/2005 Ionics 1
4/5/2005 Ultimate 1
5/5/2005 Dresser 1
5/5/2005 First 1
6/5/2005 Ofoto 1

I want the table to look like this:

Due_date Slot1 Slot2 Slot3
4/5/2005 Affina Ionics Ultimate
5/5/2005 Dresser First NULL
6/5/2005 Ofoto NULL NULL


Can somebody please help me on how to get the resultatnt table using a SQL
Query.

Or if any suggestions on how i have to go about this.

Thanks
Madhavan
Bangalore
INDIA

hi,

I am afraid that this can be possible in a single SQL.
It may be possible with analysis services like cubes.

Even Is you go for manual pivoting hoe can you identify which is in Slot1/Slot2/Slot3 ... ?

If this is possible you can do a manual pivoting with a temperory table/ table datatype (MS-sql)

Prashant