Re: Convert columns to rows

> hi,
> I need to convert columns to rows
>
> here i have sample input data
>
> weekno manager1 manager2
> 51 33454 26749
> 52 33454 26749
>
> i wnat the output like this
>
> weekno manager
> 51 33454
> 51 26749
> 52 33454
> 52 26749

select weekno, manager1 manager
 from table
union all
select weekno, manager2
from table;

--
TomekB