469,331 Members | 1,817 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Transposing rows as columns

Hello Friends,
I need your help.
I have one problem if anyone know about it then reply soon.

I have records like this:::

proj_id date total
01 2007/04 30
01 2007/05 40
01 2007/06 50
01 2007/07 60
02 2007/04 10
02 2007/05 40
02 2007/06 50
02 2007/07 80

In the above records in the date field duration is fixed for 4 months.....

And I want to convert this records like this::::

proj_id 2007/04 2007/05 2007/06 2007/07
01 ------ 30 ------ 40------ 50------ 60
02 ------ 10------ 40------ 50------ 80

I think here is the clear view.....................In above record dotted line
is only for formating so dont consider it.
Pls anyone know then give me the answer its very urgent......

Thanks
Apr 24 '07 #1
0 843

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Fabio | last post: by
8 posts views Thread by Leszek Gruszka | last post: by
2 posts views Thread by Howard William | last post: by
3 posts views Thread by Jim Heavey | last post: by
68 posts views Thread by Martin Joergensen | last post: by
9 posts views Thread by Classic-Car-World Ltd | last post: by
1 post views Thread by trizub | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.