Hi all ,

I have a Table like this ..

Project code
Date Hours
-----------
------- --------
01-1203
08/28/2009 08
01-1203
08/29/2009 08
02-1389
08/30/2009 08
02-1389
08/31/2009 08

If I query the table I need the data to be like this ...

Project 08/28/2009
08/29/2009 08/30/2009 08/31/2009
-----------
------------------ ------------------ ----------------
-----------------
01-1203
08
08
02-1389
08 08


Can anyone post a sql query for the relevant issue ?

Thanks ,
Keerthi C