Column into Row -
09-03-2009
, 06:21 AM
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 |