Transpose Rows to Columns ?
- From: bogtom@xxxxxxxxx
- Date: 29 Mar 2006 14:32:41 -0800
I have records
ID Sku Name Date
2 41 Blair 01/04/03
3 45 John 03/04/03
that should look like...
ID 2 3
Sku 41 45
Name Blair John
.....
and so on. Number of source rows will be fixed (12) so no of target
columns will be 12 too.
Anyone know of a quick way to do this via simple SQL ?
.
- Follow-Ups:
- Re: Transpose Rows to Columns ?
- From: Serge Rielau
- Re: Transpose Rows to Columns ?
- Prev by Date: Re: Optimizing SQL - Union
- Next by Date: Can this be optimized? Newbie question
- Previous by thread: Hiding NULL
- Next by thread: Re: Transpose Rows to Columns ?
- Index(es):
