Column into Row
From: keeri <ck.keerthi_at_gmail.com>
Date: Thu, 3 Sep 2009 04:21:54 -0700 (PDT)
Message-ID: <e6add266-0d78-4aad-9ccc-332b113b89c3_at_2g2000prl.googlegroups.com>
Hi all ,
01-1203
08
08
02-1389
Date: Thu, 3 Sep 2009 04:21:54 -0700 (PDT)
Message-ID: <e6add266-0d78-4aad-9ccc-332b113b89c3_at_2g2000prl.googlegroups.com>
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
Received on Thu Sep 03 2009 - 06:21:54 CDT