Can any one suggest me how to convert rows into column.
i have implemented as max( case.....). but there is problem in executing so plz help me out in this
converting rows to columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
Re: converting rows to columns
please elaborate on what you want and what is your input..........
-
- Participant
- Posts: 106
- Joined: Thu Jun 08, 2006 8:51 am
Re: converting rows to columns
Thanks,
The below is the query :-
max(case when tda.addrs_seq_nbr=1 then tda.orgnl_addrs_ln_txt else null end) orgnl_addrs_ln_1,
will the pivot stage help me out in this..
The below is the query :-
max(case when tda.addrs_seq_nbr=1 then tda.orgnl_addrs_ln_txt else null end) orgnl_addrs_ln_1,
will the pivot stage help me out in this..
That query doesn't really tell us what you are trying to accomplish. Please try to spell out in words what the problem is that you are trying to solve. Forget the "max case" query, just talk to us. Examples of your source data and what it would need to look like in the target are always helpful.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers